A connector used for importing data to and from Google BigQuery.
This connection type supports the following task types:
This connection can be used in a Data Migration.
| Usable as Source | Usable as Target | Usable as Incremental Source | Usable as Incremental Target |
|---|---|---|---|
| ✔ | ✔ | ❌ | ❌ |
| Template Name | Description |
|---|---|
| Google BigQuery | The standard connection string for Google BigQuery, that also requires an authentication file. |
A guide on how to get the required Google BigQuery authentication file can be found here.
When exporting into Parquet, if it is not specified in the connection string, Google BigQuery will default to a LOCAL offset value for any datetime offset columns. You can change the format of the datetime offset using the configuration settings here and adding it to your connection string.