BigQuery API Configuration

Request

POST https://api.fivetran.com/v1/destinations

{
  "group_id": "group_id",
  "service": "big_query",
  "region": "GCP_US_WEST1",
  "time_zone_offset": "+3",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "daylight_saving_time_enabled": true,
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "proxy_agent_id": "proxy_agent_id",
  "config": {
    "bucket": "customer-bucket",
    "secret_key": "private-key-of-the-customer-service-account",
    "project_id": "my-bigquery-project",
    "support_json_type": true,
    "data_set_location": "US"
  }
}

Config parameters

Name	Description
`bucket`	Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location.
`secret_key`	Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account.
`project_id`	BigQuery project ID
`support_json_type`	Stores JSON columns as JSON instead of STRING. This parameter is applicable only to destinations created before August 1, 2025.
`data_set_location`	Data location. Datasets will reside in this location.