​
Connecting to BigQuery

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

Create a Connector

Select the “Connectors” tab on the top page and press the “Create” button.Connection
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.BigQuery Service Account Connection Create
Field NameDescriptionRequiredExample
CredentialService Account JSON✅{"project_id": "", ...}
For creating a service account, please refer to the official page.

​
Connecting with OAuth

Select BigQuery (OAuth) and press the displayed sign-in button to authenticate with Google.BigQuery OAuth Connection CreateThe following fields are also required.
Field NameDescriptionRequiredExample
Project IDProject ID✅demo-project
DatasetDataset Namedemo_dataset
LocationLocationasia-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.Snowflake Connection Create CompleteEnter the created connector name in SQL or Python code to retrieve data.
{{
    config(
        connection="connection_name"
    )
}}

select * from table_name