Standard SQL (BigQuery)

by Nov 3, 2018

Can ADS generate SQL scripts in Standard SQL and not in Legacy SQL (i.e., without square brackets)?

Response

Thomas Conrad over 4 years ago
Hi,

You can change the quotes for BigQuery in File->Options->Scripts->Google BigQuery->Quote Identifier. You can also change the SQL type in the Server Properties->Advanced->Query Options->SQL Version.

Does that answer your question?

Thanks, Tom

Thomas Conrad over 4 years ago in reply to Thomas Conrad

Thomas Conrad over 4 years ago in reply to Thomas Conrad

Alexo over 4 years ago in reply to Thomas Conrad
Hi Tom,

yes, this helps! Cool. Thank you!