Compose for Data Warehouse : Add LABEL along with FORCE_ORDER to have better database resource control
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.
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.
