topic Re: How to set up Qlik Sense Google BigQuery connection? in Connectivity & Data Prep

How to set up Qlik Sense Google BigQuery connection?

Bo_PT — Mon, 31 Mar 2025 18:07:51 GMT

Hi, there,

I am trying to set up Google BigQuery connections in Qlik Sense and have some questions:

#1. I followed this instruction (https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/GoogleBigQuery/Create-GBQ-Connection.htm), and downloaded a CA certificate (PEM file). What should I do with this certificate? Should it be used for 'SSL Options' when creating BigQuery connection?

#2. Our server is Windows system. Based on this instruction (https://help.qlik.com/en-US/connectors/Content/Connectors_Home/Setting-encryption-key.htm), I need to set an encrypted key. In the 'Generating an encryption key' section, it says 'The key must be a secure, random string of characters between 32 and 4096 bytes in size when encoded in UTF-8 format.'. And it look like this key is used in the steps described in 'Setting an encryption key on Qlik Sense Enterprise on Windows' section. But how to generate such an encrypted key?

We are using Qlik Sense May 2024 release. Operating system: Windows Server 2022.

Thanks

Re: How to set up Qlik Sense Google BigQuery connection?

Chip_Matejowsky — Mon, 07 Apr 2025 16:44:41 GMT

Hi @Bo_PT,

Per the Help entry Setting an encrption key, you should work with your internal IT to generate the encryption key based upon the reuirements listed.

Best Regards

Re: How to set up Qlik Sense Google BigQuery connection?

Diwakar — Wed, 16 Apr 2025 07:15:45 GMT

Hello @Bo_PT

Were you able to create the connection to Big Query ?

I am working on the same and would like your inputs if you were able to create connection.

Thanks

Diwakar

Re: How to set up Qlik Sense Google BigQuery connection?

Bo_PT — Wed, 16 Apr 2025 12:21:47 GMT

Hi, @Diwakar,

Yes, I am able to create GigQuery connections in both Qlikview and Qlik Sense.

For the question #1 in my original post, I did not use PEM certificate. PEM is SSL certificate and it is optional, not required.

For the question #2, our security team generated a key file (.json) which looked something like this:
{
type": "service_account",
"project_id": "<project_id>",
"private_key_id": "<a 41-charactor-long-string>",
"private_key": "-----BEGIN PRIVATE KEY-----\n.....<a very long string>...\n-----END PRIVATE KEY-----\n",
...
"universe_domain": "googleapis.com"
}

I used this file to set up BigQuery connection and it works.

Hope this helps.

Re: How to set up Qlik Sense Google BigQuery connection?

Diwakar — Wed, 16 Apr 2025 12:33:46 GMT

Thanks @Bo_PT

This helps.

Regards,

Diwakar