BigQueryOptions Parameter (Connect-GoogleBigQuery Cmdlet)
Specifies a comma-separated list of custom Google BigQuery provider options.
Syntax
Connect-GoogleBigQuery -BigQueryOptions string
Data Type
cstr
Default Value
""
Remarks
This property enables specialized Google BigQuery behaviors that are not exposed through standard connection settings.
Supported options:
| Option | Description |
| gbqoImplicitJoinAsUnion | Preserves implicit joins rather than rewriting them as CROSS JOINs, which is the expected SQL92 behavior. BigQuery interprets implicit joins as UNION ALL, which may be useful for supporting legacy query patterns or specific transformations. |
Use this property when you need to control specific Google BigQuery behaviors that aren’t handled through other settings.