Google BigQuery
Description
A connector used for importing data to and from Google BigQuery.
Task Type Support
This connection type supports the following task types:
- Data Migration
- SQL Statement Task
Data Migration Support
This connection can be used in a Data Migration.
| Usable as Source | Usable as Target | Usable as Incremental Source | Usable as Incremental Target |
|---|---|---|---|
| ? | ? | ? | ? |
Connection String Templates
| Template Name | Description |
|---|---|
| Google BigQuery | The standard connection string for Google BigQuery, that also requires an authentication file. |
Connection Notes
-
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.