idea Compose for Data Warehouse : Add LABEL along with FORCE_ORDER to have better database resource control in Suggest an Idea

Compose for Data Warehouse : Add LABEL along with FORCE_ORDER to have better database resource control

sharmamanishv — Wed, 19 Jan 2022 16:48:01 GMT

Compose for Data Warehouse: Version 2021.8.0.372 using Azure Synapse Analytics.

Microsoft recommends adding FORCE_ORDER in queries which are resource intensive. FORCE_ORDER tells the optimizer to process the tables in the order they are listed in the query.

A LABEL tells the Synapse resource manager which workload group to use. This is a benefit since our fact table INSERT statements are the most resource intensive ones of all the instructions. Additionally this will help to dynamically set a LABEL which will allow to control the amount to resources allocated to certain specific queries and we can further try to optimize our synapse experience with compose.

Re: Compose for Data Warehouse : Add LABEL along with FORCE_ORDER to have better database resource control - Status changed to: Open - On Roadmap

TimGarrod — Wed, 26 Jan 2022 22:32:58 GMT

Apply LABELs to Synapse queries are on the roadmap for data mart processing.

Re: Compose for Data Warehouse : Add LABEL along with FORCE_ORDER to have better database resource control - Status changed to: Delivered

TimGarrod — Wed, 30 Mar 2022 18:07:30 GMT

This was delivered in the Qlik Compose 2021.8 SP12 release. Labels are auto-created by Compose for the different types of objects and data marts / DWH processes.