How to Use Standard SQL Dialect

NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.

You can specify the SQL variant, either legacy SQL or standard SQL, by adding a prefix to your code, for example:

#standardSQL
SELECT
  weight_pounds, state, year, gestation_weeks
FROM
 `bigquery-public-data.samples.natality`
ORDER BY weight_pounds DESC
LIMIT 10;