Database Reference
In-Depth Information
or on different versions of Excel, the BigQuery Excel Connector should work
with any version of Excel since Office 97.
BigQuery Excel Connector App
The first step in using BigQuery from Excel is visiting the BigQuery Excel
This page should have all the instructions necessary for integration;
although, some of the details can be tricky if you're unfamiliar with setting
up external queries in Excel. The first bit talks about a key, which you won't
have yet, so don't worry about it for now.
Click the link that says, “Click here to download the IQY file,” and save the
resulting file to your local disk. The next section describes what this file is
and how to use it, but for now, just remember where you saved it.
Next, you need to create an authorization key. Because Microsoft Excel
doesn't support OAuth2 (which hadn't been invented yet when Excel Web
Queries were created), you need to use a separate authorization mechanism.
The connector app can generate a secret key that you can use to authenticate
as you. You can revoke it at any time, and it is valid for an interval of your
choice up to 30 days.
Scroll to the bottom of the page, pick a key lifetime, and click the Create Key
button. This reloads the page, and at the top you see your new key. You can
retrieve the key again by coming back to the connector page. You need to cut
and paste it into a prompt in Excel.
The Web Query (.iqy) File
In the last section, you should have downloaded a file called
connector.iqy
. This file is just a simple text file that describes how Excel
should make requests to the BigQuery connector. Now take a look at the
contents:
WEB
1
https://bigquery-connector.appspot.com/data
q=["Query", "Enter a query:"]&
p=["Project","Enter a project ID:"]&
k=["Key", "Enter your Connector Key:"]
