Connect to BigQuery with OBDC driver

Hi

BigQuery has drivers that you can use to connect through an ODBC connection, e.g…https://cloud.google.com/blog/big-data/2016/11/how-to-connect-bigquery-to-microsoft-excel-and-other-apps-with-our-new-odbc-driver.

The drivers can be found here…https://cloud.google.com/bigquery/partners/simba-drivers/

I was able to successfully establish a connection with my BigQuery data, but in EasyMorph it kept generating errors. I did not know what SQL Dialect to use - whichever one I choose came up with different errors. At want point, the fields became visible within EasyMorph, but there was still an error on importing.

Can you point me in right direction. What Dialect should I use? Is this possible?

Many thanks

Hi Robert,

see this topic: Tip: How to query unsupported ODBC data sources.

Most excellent. Thank you!