Databases
/
BigQuery

BigQuery

How to connect

  • Display Name: Give your data source a name for use within Internal. 
  • Project ID: Unique identifier for your project (not project name). 
  • Dataset ID: Unique dataset name within your project. 
  • Upload: Upload the JSON key file for the Google Cloud service account that you created for Internal.
Note: To connect with Internal, your data source must be publicly accessible, with SSL encryption enabled, and configured to accept connections from Internal’s IP addresses.

34.66.153.118/32
35.225.125.80/32 

What happens when you connect

When you connect BigQuery to Internal, we'll generate the following for you automatically:

  1. A resource for each table in your database. Think of these as prebuilt queries, so you don't have to write queries for everything.

Internal does not support writing back to your BigQuery database. Consider reading from BigQuery and writing via APIs.

Filtering and Sorting

Internal enables filtering and sorting for all Orderable data types except ARRAY, STRUCT, and GEOGRAPHY. For a list of supported operators, see here.