Big Query Rotative Key automation

[julian_data_fighter]

Hi guys!

The company policies about GCP Services Account make the Big Query keys rotate every 7 days.

Is there any way/script to automate Qlik to update this parameter?

I just want to avoid set it again once a week 🙂

Thanks a lot.

[john_wang]

Hello @julian_data_fighter ,

It appears that using the GUI is the only effective method for this task, as the export/import functionality isn't working as expected. You might consider submitting a feature request to address this.

Regards,

John.

[Dana_Baldwin]

Hi @julian_data_fighter 

The place to submit a feature request is here, it goes directly to our Product Management team. Other users can vote it up as well: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Thanks,

Dana

[DesmondWOO]

Hi @julian_data_fighter ,

I also attempted to use the REST API to update the BigQuery key. However, since the key is in JSON format, it caused a parsing error when I imported it. I recommend submitting a support ticket so we can consult with the internal team.

Regards,
Desmond