Specifies whether to use BigQuery's legacy SQL dialect for this query. By default, Standard SQL will be used.

Syntax

Connect-GoogleBigQuery -UseLegacySQL SwitchParameter

Data Type

bool

Default Value

false

Remarks

If set to true, the query will use BigQuery's Legacy SQL dialect to rebuild the query. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/.
When UseLegacySQL is set to false, the values of AllowLargeResultSets is ignored. The query will be run as if AllowLargeResultSets is true.