BigQuery connector

You can use this connector for source endpoints.

This connector is based on Airbyte’s BigQuery connector .

Source endpoint

Configuration

Source endpoint API model

Source data type mapping

To configure a BigQuery source endpoint, provide the following settings:

Enter the Project ID from the Google Cloud console .
Specify the Default Dataset ID from your project if you are transferring a single dataset. This will make the transfer execution faster.
Copy all the contents of the Credentials JSON file to the corresponding field. Refer to the Google Cloud IAM documentation for instructions on how to do it.

To create a BigQuery source endpoint with API, use the endpoint.airbyte.BigQuerySource model.

Airbyte type	Transfer type
`integer`	int64
—	int32
—	int16
—	int8
—	uint64
—	uint32
—	uint16
—	uint8
—	float
`number`	double
—	string
`time_without_timezone`, `time_with_timezone`, `string`	utf8
`boolean`	boolean
`date`	date
`date-time`	datetime
`timestamp`, `timestamp_with_timezone`, `timestamp_without_timezone`	timestamp
`object`, `array`, `REST`...	any