Google Bigquery Connector is not showing any Catalog/projects of GCP in Qlik when validating with a service account. I have created a dataset and table in BigQuery and a service account with an editor role. I uploaded the key to Google BigQuery Connector in Qlik but when validating it is showing that "Current account doesn't have any assigned catalogs". Also no GCP project is showing in Qlik Catalogs.
After that I put all the proxy and HTAPI with trusted certificate path. I'm getting "ERROR [08001] [Qlik][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[Catalog]}".
Has anyone of you faced similar issue? Please update what is the approach you have taken?
We just faced the same. The issue was that we assigned the service account the Bigquery Data Viewer role on dataset level. Once we assigned the role on project level, we were able to select the appropriate project from the drop-down.
In our case, we moved the data into a separate project in order to limit the access of the service account.
