Skip to main content
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS

Qlik Compose: Dropping Staging tables

100% helpful (1/1)
Showing results for 
Search instead for 
Did you mean: 

Qlik Compose: Dropping Staging tables

Last Update:

Oct 3, 2023 5:54:33 AM

Updated By:


When executing the task in DWH, there is no mention of Dropping the Staging tables in the ETL statements. Qlik Compose shows the creation and truncation of these tables only:

task statements.png

Explanation of the behavior:

For TMP tables and TSTG tables, whenever the Qlik Compose engine sees a create statement for these tables, and that is the statement shown in the ETL statements list, it does a DROP for that table in the background (Silently) : 

pool-2-thread-5 2023-10-03 13:29:37.554 [engine ] [VERBOSE] [] PI# 5 BEGIN dropSilentBeforeCreate()
pool-2-thread-5 2023-10-03 13:29:37.636 [engine ] [TRACE ] [] PI# 5 Performed implicit DROP TABLE [ADAM_DWH].[dboAdam].[TSTG_Categories]
pool-2-thread-5 2023-10-03 13:29:37.636 [engine ] [VERBOSE] [] PI# 5 END dropSilentBeforeCreate()

The same behavior can be seen for all the TMP tables Qlik Compose creates.

To verify this, run the task at TRACE level logs, and look for dropSilentBeforeCreate in the logs.

The staging tables are not dropped for customer convenience. This facilitates the development of user-defined statements like Pre/Post Loading ETL and Single/Multi Table ETL, which often involve these tables. Additionally, customers find it useful to have them available for adding test data during their development process, especially when Qlik Compose is not active.


Qlik Compose 

Labels (1)
Version history
Last update:
‎2023-10-03 08:54 AM
Updated by: