3 Replies Latest reply: Feb 16, 2017 10:48 AM by Zhihong He RSS

    Connecting QlikSense to BigQuery using REST API Connector

    Lewis Anderson

      Hello There,

       

      I'm trying to make use of the REST connector to extract data from a table in Google BigQuery.

      I've used the connector to connect to a variety of sources so far (LinkedIn, Twitter, Google Maps etc).

       

      However connecting to BigQuery seems to be more complex, for obvious reasons.

      restqlikconn.JPG

      I'm not sure how to structure my URL request in order to run a SQL query on one of my tables.

       

      In the interest of your time, here are some example credentials.

       

      Project

      Project ID: MyProject

      Dataset: MyDataset

      Table: MyTable

       

      API

      Client ID: 12345.apps.googleusercontent.com

      Client Secret: 98765


      Query

      SQL Query: "SELECT * FROM [MyDataset.MyTable] LIMIT 1000"

       

      Any guidance would be appreciated.


      Thanks in advance,

      Lewis