Create a connection to load data from Google BigQuery tables and views.
Click New Connection. If you want to use an existing connection, select the connection from the list and proceed to Step 5.
Enter a Source Name for the new connection.
Use the following JSON configuration:
Property | Required | Description |
---|---|---|
sql.bigquery.projectId | Yes | The GCP project ID. Find your project ID in the Google Cloud console. |
sql.bigquery.jsonKey | Yes | The string-encoded Google service account key. Ensure the correct JSON key format. See Google’s documentation for creating a service account key. |
After you have configured the connection properties, test the connection to ensure it is working.
When the connection is successful, use the following JSON to configure additional data settings:
Property | Required | Description |
---|---|---|
sql.queryTemplate | Yes | The SQL query template for fetching data from BigQuery. |
sql.timeColumnName | Yes | The time column used for filtering data while ingesting. |
sql.timeColumnFormat | Yes | The datetime format of the time column used for filtering. |
sql.startTime | Yes | The start time for data extraction. This value is dynamically used in the $START placeholder of sql.queryTemplate . It should match the specified time column format. |
sql.endTime | Yes | The end time for data extraction. This value is dynamically used in the $END placeholder of sql.queryTemplate . It should match the specified time column format. |
Click Show Sample Data to preview the source data before finalizing the configuration.
Proceed with Data Modeling.
Create a connection to load data from Google BigQuery tables and views.
Click New Connection. If you want to use an existing connection, select the connection from the list and proceed to Step 5.
Enter a Source Name for the new connection.
Use the following JSON configuration:
Property | Required | Description |
---|---|---|
sql.bigquery.projectId | Yes | The GCP project ID. Find your project ID in the Google Cloud console. |
sql.bigquery.jsonKey | Yes | The string-encoded Google service account key. Ensure the correct JSON key format. See Google’s documentation for creating a service account key. |
After you have configured the connection properties, test the connection to ensure it is working.
When the connection is successful, use the following JSON to configure additional data settings:
Property | Required | Description |
---|---|---|
sql.queryTemplate | Yes | The SQL query template for fetching data from BigQuery. |
sql.timeColumnName | Yes | The time column used for filtering data while ingesting. |
sql.timeColumnFormat | Yes | The datetime format of the time column used for filtering. |
sql.startTime | Yes | The start time for data extraction. This value is dynamically used in the $START placeholder of sql.queryTemplate . It should match the specified time column format. |
sql.endTime | Yes | The end time for data extraction. This value is dynamically used in the $END placeholder of sql.queryTemplate . It should match the specified time column format. |
Click Show Sample Data to preview the source data before finalizing the configuration.
Proceed with Data Modeling.