Prerequisites

Before you can use Google Cloud BigQuery as a data warehouse in a Qlik Compose project, make sure the prerequisites described below have been met.

Permissions

When you create your Service Account Key for Google Cloud, make sure to select BigQuery > BigQuery Data Owner as the Role. Leave the default key type (JSON) unchanged.

As part of the Service Account Key creation process, a JSON file containing the connection information will be downloaded to your computer. You will need to copy the contents of this file to the Service account key field in the Data Warehouse settings.

Client Prerequisites

Both the Simba ODBC driver and the Simba JDBC driver need to be installed on the Compose machine.

To do this:

1. Download the following drivers from https://cloud.google.com/bigquery/providers/simba-drivers:

   • Simba ODBC driver 2.3.0 or later (MSI file)
   • Simba JDBC driver 1.2.2 or later (Zip file)
2. To install the ODBC driver, simply run the installer on the Compose machine.

3. To install the JBDC driver, extract all of the files to the <COMPOSE_INSTALL_DIR>\java\jdbc folder on the Compose machine.

   Warning noteWhen installing driver versions later than 1.2.22.1026, after extracting the files to the jdbc folder, you must delete the gson-<version>.jar file from the folder. Otherwise, an error will occur.
4. Restart the Compose service.