Configuring your connectionsConnection configurationsGoogle BigQueryConnection Description Configuration NAMETYPEDESCRIPTIONREQUIREDREADONLYproject_idstringfalsetrueclient_emailstringfalsetrueservice_accountstringtruefalselocationstringRegion or multi-region for query operationsfalsefalseoverride_project_idstringOverride service key’s project ID for cross-account accessfalsefalsestructured_values_as_jsonbooleanfalsefalse Example 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": false9 }10} Model Sync Source Configuration NAMETYPEDESCRIPTIONREQUIREDREADONLYquerystringfalsefalsedatasetstringDatasetfalsefalsetablestringTablefalsefalse Example 1{2 ...3 "configuration": {4 "dataset": "nyctaxi",5 "query": "SELECT * from sampledata.nyctaxi.taxis",6 "table": "taxis"7 }8} Bulk Sync Destination Configuration NAMETYPEDESCRIPTIONREQUIREDREADONLYadvancedobjectfalsefalsedatasetstringOutput datasetfalsefalsemirror_schemasbooleanMirror schemasfalsefalse Example 1{2 ...3 "destination_configuration": {4 "advanced": {5 "hard_deletes": false,6 "table_prefix": "",7 "truncate_existing": false8 },9 "dataset": "dataset",10 "mirror_schemas": false11 }12}