BigQuery

Connecting to BigQuery

For an overview of the connector, please refer to the following link.

• Connecting to DB/SaaS

Dashboard

1. Create a Connector

   Select the “Connectors” tab on the top page and press the “Create” button.

   
2. Enter BigQuery Credentials

   BigQuery offers two authentication methods.

   Connecting with Service Account

   Select BigQuery (Service Account) and enter the credentials in the displayed form.

   

   Field Name	Description	Required	Example
   Credential	Service Account JSON	✅	{"project_id": "", ...}

   For creating a service account, please refer to the official page.

   • Create a Service Account

   Connecting with OAuth

   Select BigQuery (OAuth) and press the displayed sign-in button to authenticate with Google.

   

   The following fields are also required.

   Field Name	Description	Required	Example
   Project ID	Project ID	✅	demo-project
   Dataset	Dataset Name		demo_dataset
   Location	Location		asia-northeast1

   After entering the information, press the Create button to complete the creation. If there are any errors, please check the connection details again.

3. Connect to the Created Database

   Once created successfully, you can retrieve the connector name from the list. The string next to the icon is connection_name. You can use this to connect to the database in your code.

   

   Enter the created connector name in SQL or Python code to retrieve data.

   SQL

   {{
       config(
           connection="connection_name"
       )
   }}
   
   select * from table_name