A connection-level property to customize query behavior. Under JDBC, these correspond directly to connection properties passed to the DriverManager. Under ODBC, these correspond to properties in the connection string.
Currently supported connection properties:
dataset_project_id: represents the default project for datasets that are used in the query. Setting the system variable @@dataset_project_id achieves the same behavior. For more information about system variables, see: https://cloud.google.com/bigquery/docs/reference/system-variables
time_zone: represents the default timezone used to run the query.
session_id: associates the query with a given session.
query_label: associates the query with a given job label. If set, all subsequent queries in a script or session will have this label. For the format in which a you can specify a query label, see labels in the JobConfiguration resource type: https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#jobconfiguration
service_account: indicates the service account to use to run a continuous query. If set, the query job uses the service account to access Google Cloud resources. Service account access is bounded by the IAM permissions that you have granted to the service account.
Additional properties are allowed, but ignored. Specifying multiple connection properties with the same key returns an error.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-02 UTC."],[[["\u003cp\u003eConnection properties customize query behavior, mapping to JDBC connection properties or ODBC connection string properties.\u003c/p\u003e\n"],["\u003cp\u003eSupported connection properties include \u003ccode\u003edataset_project_id\u003c/code\u003e, \u003ccode\u003etime_zone\u003c/code\u003e, \u003ccode\u003esession_id\u003c/code\u003e, \u003ccode\u003equery_label\u003c/code\u003e, and \u003ccode\u003eservice_account\u003c/code\u003e, each serving a specific purpose in query execution.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003edataset_project_id\u003c/code\u003e property sets the default project for datasets in the query, and is equivalent to setting the system variable \u003ccode\u003e@@dataset_project_id\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eConnection properties are represented in JSON format with a \u003ccode\u003ekey\u003c/code\u003e and \u003ccode\u003evalue\u003c/code\u003e, where both are strings.\u003c/p\u003e\n"],["\u003cp\u003eSpecifying duplicate keys in connection properties is not allowed and results in an error.\u003c/p\u003e\n"]]],[],null,[]]
