Database Reference
In-Depth Information
you'd like to turn into pretty graphs. Like Tableau, BIME has a free trial that
you can use to try it out while you're deciding if it is right for your needs.
Connecting BIME to Your BigQuery Tables
In order to use BIME with BigQuery, follow these steps:
1. Sign up for BIME by clicking on the Try BIME Free button at
http://www.bimeanalytics.com/index.html
. After you
complete the signup process, you will receive a custom URL that you
can use to connect to the service. For our trial, it was
2. Navigate to the custom BIME URL and click on the Create Connection,
which should be visible on the landing page. After clicking it, it brings
up the Create Connection dialog box.
Figure 13.7
shows the various
options, with BigQuery in the bottom-left corner.
3. Select BigQuery and then press Next. You'll be prompted to name the
connection; call it
Shakespeare
because you want to connect to the
public
shakespeare
table.
4. Click the Connect with Google button. This brings up a web page with
the standard Google OAuth2 prompt. It asks you to log in to your
Google account (if you're not already logged in), and then whether you
want to allow BIME to view and manage your data in BigQuery. After
you approve the access, you have to cut and paste a verification code
that BIME then uses to access your BigQuery tables in the future.
5. Next, click the … next to the Table prompt. This brings up the BigQuery
Explorer dialog box, as shown in
Figure 13.8
, where you can select the
project, dataset, and table that you'd like to connect to. For this
example, select
publicdata
,
samples
, and then
shakespeare
. Press
Select, and it takes you back to the General tab with the table name
filled out.
6. Click on Next one more time, and BIME will pull down the schema of
the table and present you with a dialog box that lets you select columns.
If you want all your columns to be available in your visualizations, you
can just ignore this dialog box and press Next again.
7. The Cloud Storage tab is where you can tell BIME where you want to
store your data if you want to store it elsewhere. If you have Oracle data,
