topic Big Query Rotative Key automation in Qlik Replicate

Big Query Rotative Key automation

julian_data_fighter — Thu, 07 Nov 2024 09:38:19 GMT

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.

Re: Big Query Rotative Key automation

john_wang — Thu, 07 Nov 2024 15:32:54 GMT

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.

Re: Big Query Rotative Key automation

Dana_Baldwin — Thu, 07 Nov 2024 16:58:08 GMT

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

Re: Big Query Rotative Key automation

DesmondWOO — Fri, 08 Nov 2024 08:30:14 GMT

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