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 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 |