Creating a Google BigQuery connection
Written by
Updated at May 6, 2024
Note
To create a BigQuery connection, make sure the service account is granted the BigQuery Data Viewer
This connection does not support operations with partitioned tables.
To create a BigQuery connection:
-
Go to the connections page
. -
Click Create connection.
-
Select a BigQuery connection.
-
Specify the connection parameters:
- Project ID: Specify the ID of your project in Google Cloud.
- Service account private key: Click Attach file and upload a file with your Google Cloud service account's authorized key for authentication. For more information on how to get a file with a key, see the Google documentation
. - Raw SQL level: Enables you to use an ad-hoc SQL query to generate a dataset.
- Cache TTL in seconds: Specify the cache time-to-live or leave the default value. The recommended value is 300 seconds (5 minutes).
-
Click Create connection. If you use a new DataLens object model with workbooks and collections, select or create a workbook to save the connection to.
-
Enter a name for the connection and click Create.
Note
You can check the host connection before creating it. To do this, click Check connection.