Creating a Google BigQuery connection
Written by
Updated at October 11, 2024
Note
To create a connection for a service account in BigQuery, make sure the service account has the BigQuery User role for a dataset.
This connection does not support operations with partitioned tables.
To create a BigQuery connection:
-
Open the page for creating a new connection.
-
Under Databases, select the 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).
-
(Optional) Make sure the connection works properly. To do this, click Check connection.
-
Click Create connection.
-
Select a workbook to save your connection to or create a new one. If using legacy folder navigation, select a folder to save the connection to. Click Create.
-
Enter a name for the connection and click Create.