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


      # Have Google account with access to BigQuery

      # Obtain API access by following these steps:

      # Download the Standalone version of the driver, and the dependencies for Kettle from:

      #  You can find the following steps at the drivers wiki page:
           Copy the driver file _bqjdbc-1.4-standalone.jar_ into *libext\JDBC*
           Copy the _contents_ of the dependencies zip into 
            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:
               The Drivers Class Name is:

      # Click on TEST, it should say OK