Hi Team,
Recently we upgraded to the Querystudio 2,however while running the query its erroring out with the error message as "Insufficient privileges". However we were able to run the query in the Querystudio 1 without any issues. We also verified the permission settings and found out to be the "Update Data Extension" requires for the Query studio 2 to be executed. Could you please check why this was introduced withe the "Update" permission to be added. We will not be able to provide the "Update DE" permission what are the other option to execute the queries from Query studio 2?
#Salesforce Admin
Query Studio 2 in Marketing Cloud introduces tighter schema validation and automated target data extension provisioning compared to the legacy version. Under the hood, it evaluates your SQL and automatically manages data extension creation and modifications based on your queries, enforcing stricter write permissions that require update capabilities on target structures. If your security model restricts providing update permissions directly, you can utilize a standard Query Activity in Automation Studio where you can control the target action independently, or adjust your settings to use a temporary scratch data extension method that bypasses ongoing update rights on production tables.
