Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

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