Create Big Query connection through automation

LucasQlikster — Tue, 25 Mar 2025 15:47:24 GMT

I am trying to create a service account Big Query connection in an OEM solution for all sub-tenants using Qlik Platform Operations and the path 'data-connections'. However the api-call doesn't work, instead it gives me the error that 'Unable to connect to database: [Qlik][BigQuery] (8706) Unable to open keyfile'.

What can be done to solve this? My post request looks like this:

{

"dataSourceId": "gbq",

"qName": "Google_BigQuery",

"space": "<space_name>",

"connectionProperties": {

"OAuthMechanism":"0",

"KeyFilePath": [

{

"name": "keyfile.json",

"value": "<base64-encoded-json-file>"

}

"Email": "<service account email, same as in Json-file>",

"Catalog": "<main catalogue in BQ>",

"credentialsName":"<name>"

}

topic Create Big Query connection through automation in Qlik Automate

Create Big Query connection through automation