Big query automation connection using service account
In one of our projects, we're implementing writeback functionality using Qlik Cloud. However, we've encountered a limitation: when setting up the automation connection for Google BigQuery—specifically for the "Insert One Record" block—there's currently no option to authenticate via a service account.
At the organizational level, individual user access to write data from Qlik to BigQuery is not permitted. We're required to use Qlik's service account credentials (IAM) for storing data in BigQuery tables from qlik. Given this constraint, we're exploring possible workarounds, but so far, no viable solution has emerged. Is there any way out to resolve this issue?
