You can set the SQL variant, either legacy SQL or standard SQL, by including a prefix to your query, e.g.:
#standardSQL
SELECT
weight_pounds, state, year, gestation_weeks
FROM
`bigquery-public-data.samples.natality`
ORDER BY weight_pounds DESC
LIMIT 10;
0 Comments