Connecting Qlik Sense to your Kaivo-managed BigQuery data warehouse enables you to load, transform, and analyze your data directly within Qlik Sense apps and dashboards. You can authenticate your connection using either a Google Account or a Service Account.

Option A: Connect Using a Google Account

Use this method if you originally signed up for Kaivo using your Google Account.

Step 1: Open the BigQuery Connector

1. Open your Qlik Sense workspace and navigate to your app.

2. Click Add data (or open the Data load editor).

3. Select Google BigQuery from the list of available data connectors.

Step 2: Set Authentication to User Authentication

1. In the connection settings window, locate the OAuth Mechanism dropdown.

2. Select User Authentication.

3. Click the Sign In button.

Step 3: Complete Google Authorization

1. A new browser window will open prompting you to sign in with Google.

2. Log into the Google Account associated with your Kaivo account and click Allow to grant Qlik permissions.

3. Copy the confirmation code displayed on screen.

4. Return to Qlik Sense, paste the string into the Confirmation Code field, and click Validate.

Step 4: Select Your Project and Load Data

1. Select your Kaivo project from the Catalog / Project dropdown menu.

2. Select your desired dataset and tables.

3. Name your connection and click Create (or Insert script / Add data) to finalize.

Option B: Connect Using a Service Account

Use this option if you want to use dedicated credentials for automated app reloads or shared team spaces.

Step 1: Obtain Your Kaivo Service Account Credentials

1. Log into your Kaivo application in a separate browser tab.

2. Navigate to the Service Account settings page.

3. Create/generate a service account and download the JSON keyfile (or copy its contents) to your computer. Guide on how to create a service account is here: Setup Service Account.

Step 2: Open the Connector and Select Service Authentication

1. In Qlik Sense, go to Add data or the Data load editor.

2. Choose Google BigQuery.

3. In the OAuth Mechanism dropdown, select Service Authentication.

Step 3: Configure Service Account Details

1. Enter your service account email address in the Email field.

2. Upload or browse for your downloaded Key File (JSON format).

3. Click Validate to establish the connection with BigQuery.

Step 4: Map Project and Select Tables

1. From the Catalog / Project dropdown menu, select your unique Kaivo project ID.

2. Select the datasets and tables you wish to import.

3. Assign a connection name and click Create & Load to begin analyzing your data.

Support Note: If you need help identifying your Project ID or configuring service accounts, please reach out via the chat widget in the bottom-right corner of your Kaivo application.

For a visual demonstration of the authentication flow and selecting datasets within Qlik, check out Connecting Qlik Sense to Google BigQuery. This video provides a helpful walkthrough of the Google OAuth validation process and table selection inside Qlik Sense.