Data Warehouse Load Shows Success Despite SQL Script Error at Post Loading ETL in Qlik Compose
Hi everyone,
I'm encountering an issue with Qlik Compose where the data warehouse load is marked as successful even though there is an error in the SQL script in Post Loading ETL. When I run the SQL script separately, it fails due to a column mismatch error during insertion.
Why doesn't Qlik Compose stop or fail when the script in the post-loading phase encounters an error? Any insights or solutions would be greatly appreciated.