Tries to generate rollback when one exists

General Discussion
1

When I deploy to Snowflake everything works correctly but when I attempt to rollback to prove it’s working correctly I get an error message.

Code

--liquibase formatted sql

--changeset itw-datahub:ddl_dhub_9643_v2026_fr1.sql runOnChange:true

UPDATE DATA_HUB_DQ_CTRL.ALERTS_QUERIES_CONFIG

SET QUERY = ‘select ‘‘DATA_HUB_ALERT.STNDNG_STLMT_INSTRUCT_UPDT_DT’’ as TABLENAME,data.DIFF_MINS as DIFF_MINS,data.RAW_RCRD_KEY as RAW_RCRD_KEY from (select CONVERT_TIMEZONE(’‘America/New_York’‘,’‘UTC’‘,src_efctv_start_ts::TIMESTAMP_NTZ) as SRC_EFCTV_START_TS_UTC,efctv_start_ts as EFCTV_START_TS_UTC,DATEDIFF(’‘minute’‘,CONVERT_TIMEZONE(’‘America/New_York’‘,’‘UTC’‘,src_efctv_start_ts::TIMESTAMP_NTZ),efctv_start_ts) as DIFF_MINS,RAW_RCRD_KEY from ITW.DATA_HUB_ALERT.STNDNG_STLMT_INSTRUCT_UPDT_DT where EXPRD_IND=’‘false’’ and DATEDIFF(‘‘minute’’, SRC_EFCTV_START_TS_UTC, SYSDATE()) < 60 and DAYOFWEEKISO(src_efctv_start_ts) != 6 order by efctv_start_ts desc limit 1) data where data.DIFF_MINS > 10’

WHERE ID = 1547;

--rollback UPDATE DATA_HUB_DQ_CTRL.ALERTS_QUERIES_CONFIG SET QUERY = ‘select ‘‘DATA_HUB_ALERT.STNDNG_STLMT_INSTRUCT_UPDT_DT’’ as TABLENAME,data.DIFF_MINS as DIFF_MINS,data.RAW_RCRD_KEY as RAW_RCRD_KEY from (select CONVERT_TIMEZONE(’‘America/New_York’‘,’‘UTC’‘,src_efctv_start_ts::TIMESTAMP_NTZ) as SRC_EFCTV_START_TS_UTC,efctv_start_ts as EFCTV_START_TS_UTC,DATEDIFF(’‘minute’‘,CONVERT_TIMEZONE(’‘America/New_York’‘,’‘UTC’‘,src_efctv_start_ts::TIMESTAMP_NTZ),efctv_start_ts) as DIFF_MINS,RAW_RCRD_KEY from ITW.DATA_HUB_ALERT.STNDNG_STLMT_INSTRUCT_UPDT_DT where EXPRD_IND=’‘false’’ order by efctv_start_ts desc limit 1) data where data.DIFF_MINS > 10’ WHERE ID = 1547;

Error

org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.liquibase:liquibase-maven-plugin:4.24.0:rollback (default-cli) on project liquibase-itw-tradearchive-snowflake: 
Error setting up or running Liquibase:
liquibase.exception.LiquibaseException: liquibase.exception.RollbackFailedException: liquibase.exception.RollbackFailedException: Liquibase does not support automatic rollback generation for raw sql changes (did you mean to specify keyword "empty" to ignore rolling back this change?)

Obviously, there is a rollback directive but for some reason Liquibase isn’t recognizing it.

2

How are you including this file in you main changelog? via “include” or “sqlFile”?