Google BigQuery
Getting Data from Google BigQuery using Starschema's JDBC driver
Installation
# Have Google account with access to BigQuery
# Obtain API access by following these steps:
https://code.google.com/p/starschema-bigquery-jdbc/wiki/JDBCURL
# Download the Standalone version of the driver, and the dependencies for Kettle from:
https://code.google.com/p/starschema-bigquery-jdbc/downloads/list
# You can find the following steps at the drivers wiki page:
https://code.google.com/p/starschema-bigquery-jdbc/wiki/PentahoDataIntegrationakaKettle
* Copy the driver file _bqjdbc-1.4-standalone.jar_ into *libext\JDBC*
* Copy the _contents_ of the dependencies zip into
data-integration\libswt\win32
data-integration\libswt\win64
Depending on your windows version (32bit (x86) - 64bit (x64)
# Start Spoon and add a new Database connector using *Generic database*
More information about the driver URL can be found at:
https://code.google.com/p/starschema-bigquery-jdbc/wiki/JDBCURL
The Drivers Class Name is:
_net.starschema.clouddb.jdbc.BQDriver_
# Click on TEST, it should say OK