The BigQuery connector
Note
This connector is based on Airbyte
You can use this connector for source endpoints.
Source endpoint
Configuration
Source endpoint API model
Source data type mapping
-
Provide your 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
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 |