Specifies the Google BigQuery table where query results are stored.

データ型

string

デフォルト値

""

解説

Google BigQuery enforces limits on the size of query results returned directly. If a query exceeds this limit, it fails with an error such as "Response too large to return".

Setting this property allows the connector to write query results to a table in Google BigQuery, bypassing the response size limit. The driver retrieves results from the specified table after execution.

The value format depends on the SQL dialect in use:

• Standard SQL: project-name.dataset-name.table-name
• Legacy SQL (when UseLegacySQL is enabled): project-name:dataset-name.table-name

If you use this property with multiple connections, assign a unique destination table to each connection. Sharing a destination table between concurrent queries can cause data loss, as results may overwrite each other.

Use this property for queries expected to return large result sets or when using passthrough queries that require storing results explicitly in Google BigQuery.