Steps to connect to a Google BigQuery database
Last updated
Was this helpful?
Last updated
Was this helpful?
Navigate to Data -> Connect -> Create new -> BigQuery.
Enable the Use validated datasource connection details toggle if you want to connect to an already established connection.
The fields get filled automatically as per the saved connection details. Click on Browse Tables.
If you're connecting for the first time, then provide the following details:
Datasource name - The name or identifier for the BigQuery data source you want to connect to.
Project ID - The unique ID for your Google Cloud project where the BigQuery resources are located.
Billing Project (optional) - If different from your main project, this is the Google Cloud project ID that will be responsible for covering the costs associated with your BigQuery usage.
Service account key - JSON key details associated with a service account, granting access and authentication for Tellius to interact with BigQuery.
From Tellius v4.3, users no longer need to upload JSON keys repeatedly for datasets linked to the same Google service account. This change makes it easier for teams who don't have direct access to JSON keys and reduces security risks by minimizing the need to circulate these keys.
Is it a View (instead of a physical table)? - Specify whether the data source is a "View" (a virtual table created by a query) in BigQuery, as opposed to a "physical table" which is a standard, stored table with data.
Project ID (Optional): ID of your Google Cloud project, which is optional but necessary if you want to access datasets from a specific project in BigQuery.
Dataset (Schema): The specific dataset within BigQuery you want to connect to.
Click on Save and Browse Tables.
The list of tables will be displayed on the right under Select a table tab.
Select the required tables from the Available window and move to the Selected window.
Click on Import to import the selected tables.
Once the connection has been successfully created, it is listed on the Dataset page.
Starting from v4.3, we will decommission support for Google BigQuery connections via the GCS bucket route.
For details about the service account creation, please check out