# Connect to BigQuery with OBDC driver

**URL:** <https://community.easymorph.com/t/connect-to-bigquery-with-obdc-driver/631>\
**Category:** General Q&A\
**Created:** [July 16, 2018, 11:43pm UTC](https://community.easymorph.com/t/connect-to-bigquery-with-obdc-driver/631 "2018-07-16T23:43:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Lipschitz](https://community.easymorph.com/user_avatar/community.easymorph.com/robert_lipschitz/32/434_2.png) [@Robert\_Lipschitz](https://community.easymorph.com/u/Robert_Lipschitz)\
**Post date:** [July 16, 2018, 11:43pm UTC](https://community.easymorph.com/t/connect-to-bigquery-with-obdc-driver/631/1 "2018-07-16T23:43:21Z")

</div>

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](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/](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

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [July 16, 2018, 11:54pm UTC](https://community.easymorph.com/t/connect-to-bigquery-with-obdc-driver/631/2 "2018-07-16T23:54:46Z")

</div>

Hi Robert,

see this topic: [Tip: How to query unsupported ODBC data sources](https://community.easymorph.com/t/tip-how-to-query-unsupported-odbc-data-sources/622).

---

<div class="post-metadata">

**Author:** ![Robert\_Lipschitz](https://community.easymorph.com/user_avatar/community.easymorph.com/robert_lipschitz/32/434_2.png) [@Robert\_Lipschitz](https://community.easymorph.com/u/Robert_Lipschitz)\
**Post date:** [July 17, 2018, 6:57am UTC](https://community.easymorph.com/t/connect-to-bigquery-with-obdc-driver/631/3 "2018-07-17T06:57:03Z")

</div>

Most excellent. Thank you!