SQL examples for ODBC

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Google BigQuery.

• Call stored procedure (Native SQL)
• Create table / run DDL (Native SQL)
• Delete dataset
• Delete multiple records (DML) (Native SQL)
• DROP table (if exists) / other DDL (Native SQL)
• INSERT datetime / Unix timestamp values (Native SQL)
• INSERT multiple rows from any ODBC source (DSN)
• INSERT multiple rows from JSON files / API
• INSERT multiple rows from SQL Server
• INSERT single row
• List datasets
• List projects
• List tables
• Query using complex SQL (Native SQL)
• Query using simple SQL (Native SQL)
• Query with CAST unix TIMESTAMP as datetime (Native SQL)
• UPDATE table data for complex types (RECORD, Geography, JSON) (Native SQL)