ODBC guide

Query using simple SQL (Native SQL)


Native SQL — the SQL runs on the BigQuery side (server-side). Prefix the SQL with #DirectSQL to use this mode. Example queries a public dataset table (bigquery-public-data.samples.wikipedia); you can use your own or other free datasets (e.g. nyc-tlc.yellow.trips). Table name has three parts: [Project.]Dataset.Table.

#DirectSQL
SELECT *
FROM bigquery-public-data.samples.wikipedia
LIMIT 1000