Skip to main content

Suggest an Idea

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

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

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

sharmamanishv
Contributor III
Contributor III

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.

Tags (1)
2 Comments
TimGarrod
Employee
Employee

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

Status changed to: Open - On Roadmap
TimGarrod
Employee
Employee

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.

TimGarrod_0-1648663606172.png

 

Status changed to: Delivered