Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW

Tailored permissions for Big Query as destination

mic_lau
Partner - Contributor III
Partner - Contributor III

Tailored permissions for Big Query as destination

At the moment Qlik Replicate needs "Project Editor" permissions to use Google Big Query as destination. It is a "powerful" permission and enable who owns the Service Account Key to create/modify/delete everything in the project. In this way a correct segregation of roles is not achieved and responsabilities go beyond what is expected in AMS.
Is it possible to tailor a more specific set of permissions needed by Qlik Replicate to use Big Query as a source?

2 Comments
mic_lau
Partner - Contributor III
Partner - Contributor III

These are the privileges that the client and GCP specialists believe are necessary:

  • Pre-existing roles:
    • BigQuery Data Owner, only on the specific destination dataset
    • BigQuery User
    • BigQuery Job User

  • Custom role BigQuery Replicate, with the following specific permissions:
    • bigquery.datasets.create
    • bigquery.datasets.get 
    • bigquery.tables.create 
    • bigquery.tables.delete
    • bigquery.tables.get
    • bigquery.tables.getData
    • bigquery.tables.list
    • bigquery.tables.updateData
    • resourcemanager.projects.get 

 

Shelley_Brennan
Employee
Employee
 
Status changed to: Open - Collecting Feedback