![]() ![]() Instead, select the connection type tab for "Default or Custom." Go to the Data tab, and select "New Query -> From Other Sources -> From ODBC."Ĭhoose "Google BigQuery" as the data source. Once the ODBC driver is configured, open Excel. You'll need to provide credentials, either with a service account key or user authentication. Follow the instructions in the user guide or quickstart guide to configure the driver. The installer writes a user guide to the installation directory (in my case: C:/Program Files/Simba ODBC Driver for Google BigQuery). Note that the ODBC drivers are not compatible with Excel on macOS.įirst, install the BigQuery ODBC driver. Google BigQuery enables standard SQL queries to petabytes of data, but what if software you depend on doesn't support the BigQuery API? With the release of BigQuery ODBC drivers, it’s now easier than ever to connect an enterprise application to BigQuery - simply use the drivers to connect BigQuery to the tools that analysts and data scientists already use.Īs an example, I'll show you how to use the ODBC drivers to connect BigQuery to Microsoft Excel® 2016 on Windows® and visualize data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |