This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

Google BigQuery pivot table reports

Google BigQuery can be used as a data source with SQL-compatible database connector and Simba ODBC driver.

There are no any limitations on the dataset size and in this you can get reports by billions-size datasets in the near real-time. See this youtube video where 1.3Gb data is aggregated by BigQuery in seconds and displayed as pivot table by SeekTable.

BigQuery connection setup

Connection String should be a valid connection string for Simba ODBC driver for Google BigQuery; for example:

Driver=Simba ODBC Driver for Google BigQuery;OAuthMechanism=1;RefreshToken=your_google_oauth_refresh_token;Catalog=your_api_project_id;

Catalog	The name of your BigQuery project. This project is the default project that the Simba ODBC Driver for Google BigQuery queries against.
RefreshToken	The refresh token that you obtain from Google for authorizing access to BigQuery. Section below explains how to generate the token.

How to get a refresh token

If you don't have a refresh token you get it in one of the following ways:

Use your user account to generate Google OAuth client ID credentials and then use Google OAuth 2.0 Playground to generate a refresh token. Note that in this case you'll need to specify ClientId and ClientSecret in the connection string.
Use Simba-provided credentials as described in Simba's documentation or just follow these steps:
1. Open this link to generate Authentication Token.
2. Enter your Authentication Token here to get a refresh token:

Looking for embedded solution? Try PivotData microservice which can be seamlessly integrated into any web application for pivot tables generation by Google BigQuery with simple web API.