1
{
2
  "name": "bigquery connection",
3
  "type": "bigquery",
4
  "configuration": {
5
    "location": "us-east1",
6
    "override_project_id": "",
7
    "service_account": "",
8
    "structured_values_as_json": false
9
  }
10
}

1
{
2
  ...
3
  "configuration": {
4
    "dataset": "nyctaxi",
5
    "query": "SELECT * from sampledata.nyctaxi.taxis",
6
    "table": "taxis"
7
  }
8
}

1
{
2
  ...
3
  "destination_configuration": {
4
    "advanced": {
5
        "table_prefix": "",
6
        "truncate_existing": false
7
    },
8
    "dataset": "dataset",
9
    "mirror_schemas": false
10
  }
11
}