Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

Connecting QlikSense to BigQuery using REST API Connector

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

4 Replies
yigalbenoren
New Contributor

Re: Connecting QlikSense to BigQuery using REST API Connector

Hi Lewis,

I have the same problem . did you find any solution ?

Thanks,

Yigal

karthiks_dwbi
Contributor II

Re: Connecting QlikSense to BigQuery using REST API Connector

I guess you should give webUI URL here and after creating connection you would prompted to give SQL query.

geminihzh
Valued Contributor

Re: Connecting QlikSense to BigQuery using REST API Connector

Hi,

You can get the URL from the opened QlikWebConnector pagei n the browser.

Check the attachement below, as Qlik suggested, you should use the URL in "create new connection -> Web file".

bigquery_url.PNG

maxalander
New Contributor III

Re: Connecting QlikSense to BigQuery using REST API Connector

Hi Lewis,

I'm just about to set-up a connector my self, so I haven't tried this yet. However, I you could find many answers to your questions here API Reference  |  BigQuery  |  Google Cloud Platform‌.

I hope it helps!