skip to main content
Using the driver : Standard and legacy SQL support
  

Try DataDirect Drivers Now

Standard and legacy SQL support

The driver supports both standard and legacy SQL dialects of Google BigQuery. By default, the driver uses standard SQL to execute queries. However, you can change the dialect to legacy SQL either by adding the prefix #legacySQL to a query or by setting the Syntax connection property to legacy (Syntax=legacy).
The following example demonstrates how to use the prefix #legacySQL in a query:
#legacySQL
SELECT ID,name FROM [bigquery-public-data:samples.EMP]
WHERE name CONTAINS "RA";