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.