Specifies whether to use Google BigQuery's Legacy SQL dialect instead of Standard SQL when generating queries.

データ型

bool

デフォルト値

false

解説

By default, the 本製品 uses Standard SQL, which is the recommended and more feature-rich dialect supported by Google BigQuery.

When this property is set to true, the 本製品 generates queries using Google BigQuery’s Legacy SQL dialect. Legacy SQL has different syntax and semantics and does not support certain modern features.

Key behavioral differences:

• When UseLegacySQL is set to true, the value of AllowLargeResultSets is used during query generation.
• When UseLegacySQL is set to false, the 本製品 uses Standard SQL, and AllowLargeResultSets is ignored. Queries behave as if that property is always enabled.

Enable this property only if your environment requires compatibility with Legacy SQL, such as when working with legacy views, tools, or scripts that depend on that dialect. Standard SQL is generally more performant and flexible and is recommended for most use cases.