QlikSense On BigQuery
  • 28 Jul 2021
  • 1 Minute to read
  • Dark
    Light
  • PDF

QlikSense On BigQuery

  • Dark
    Light
  • PDF

Article Summary

Your connection details will vary, depending on whether your data warehouse is built on Amazon Redshift or Google BigQuery.

To determine whether your data warehouse is built on BigQuery or Redshift, see the BI Connect Page on the Panoply platform.

Panoply on BigQuery

To connect QlikSense to BigQuery:

  1. In Panoply, click on BI Connection in the top menu to view your connection details. You will need these details in Step 4.

qlicksense connect.png

  1. Log In to your Qlik Sense account. Click Add new. Select Add New Data > Connect to Data.

qliksense-1.png

  1. Under Add data connection, search for Google BigQuery.

qlicksense 2.png

  1. Under OAuth Mechanism, select User Authentication. Click on Sign In.

Qlicksense 3.png

  1. You will be re-directed to Google Sign-In page.  Sign In using the credentials under the BI Connection Tab on your Panoply account found in Step 1.

qlicksense 4.png

  1. Click Next.
  2. You will be asked to authorize Qlik Web Connectors to access your Google Account. Click on Allow.

Qlicksense 5.png

  1. A Confirmation Code will be generated to authenticate your account. Copy the code.

Qlicksense 6.png

  1. Paste the code under Confirmation Code and click on Validate.

qlicksense 7.png

  1. Your “Project ID” will be populated under Catalog(Project) and Name. Click on Create and analyze.

qlicksense 8.png

  1. You have successfully created your Google BigQuery Data Source connection.
  2. To connect with all Panoply’s native Data sources, please select “panoply” under Owner.
  3. Click on Next to get started.

    qlicksense 9.png

You have successfully connected QlikSense to your BigQuery data warehouse.


Was this article helpful?

What's Next