Alter Dynamic Table - Log Level

alterDynamicTable alterLogLevel

Last updated: January 27, 2026

Modifies the log level for a dynamic table.

Known limitations:

This change type does not support automatic rollback.
Snowflake snapshots created with Liquibase Secure 5.1 are incompatible with earlier versions due to enhanced object type detection for TABLES and VIEWS. Regenerate all snapshots with 5.1 after upgrading to avoid false differences in diff and diff-changelog operations.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the table	No
`schemaName`	String	Name of the schema containing the table	No
`tableName`	String	Name of the dynamic table to alter	Yes
`ifExists`	Boolean	Only execute if the table exists	No

alterLogLevel nested attributes

Attribute	Type	Description	Required
`newLogLevel`	String	New log level (e.g., `INFO`, `DEBUG`, `ERROR`)	No*
`unsetLogLevel`	Boolean	If true, unsets the log level	No*

*Exactly one of newLogLevel or unsetLogLevel must be specified.

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set log level -->
    <changeSet id="set-log-level" author="examples">
        <pro-snowflake:alterDynamicTable tableName="DEBUG_SUMMARY">
            <pro-snowflake:alterLogLevel newLogLevel="DEBUG"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

    <!-- Unset log level -->
    <changeSet id="unset-log-level" author="examples">
        <pro-snowflake:alterDynamicTable tableName="DEBUG_SUMMARY">
            <pro-snowflake:alterLogLevel unsetLogLevel="true"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-log-level",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "DEBUG_SUMMARY",
              "alterLogLevel": {
                "newLogLevel": "DEBUG"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-log-level",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "DEBUG_SUMMARY",
              "alterLogLevel": {
                "unsetLogLevel": true
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set log level
  - changeSet:
      id: set-log-level
      author: examples
      changes:
        - alterDynamicTable:
            tableName: DEBUG_SUMMARY
            alterLogLevel:
              newLogLevel: DEBUG

  # Unset log level
  - changeSet:
      id: unset-log-level
      author: examples
      changes:
        - alterDynamicTable:
            tableName: DEBUG_SUMMARY
            alterLogLevel:
              unsetLogLevel: true

--liquibase formatted sql

--changeset examples:set-log-level
-- Set log level
ALTER DYNAMIC TABLE MYDB.PUBLIC.DEBUG_SUMMARY SET LOG_LEVEL = 'DEBUG';

--changeset examples:unset-log-level
-- Unset log level
ALTER DYNAMIC TABLE MYDB.PUBLIC.DEBUG_SUMMARY UNSET LOG_LEVEL;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Set log level -->
    <changeSet id="set-log-level" author="examples">
        <pro-snowflake:alterDynamicTable tableName="DEBUG_SUMMARY">
            <pro-snowflake:alterLogLevel newLogLevel="DEBUG"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

    <!-- Unset log level -->
    <changeSet id="unset-log-level" author="examples">
        <pro-snowflake:alterDynamicTable tableName="DEBUG_SUMMARY">
            <pro-snowflake:alterLogLevel unsetLogLevel="true"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "set-log-level",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "DEBUG_SUMMARY",
              "alterLogLevel": {
                "newLogLevel": "DEBUG"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "unset-log-level",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "DEBUG_SUMMARY",
              "alterLogLevel": {
                "unsetLogLevel": true
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Set log level
  - changeSet:
      id: set-log-level
      author: examples
      changes:
        - alterDynamicTable:
            tableName: DEBUG_SUMMARY
            alterLogLevel:
              newLogLevel: DEBUG

  # Unset log level
  - changeSet:
      id: unset-log-level
      author: examples
      changes:
        - alterDynamicTable:
            tableName: DEBUG_SUMMARY
            alterLogLevel:
              unsetLogLevel: true

--liquibase formatted sql

--changeset examples:set-log-level
-- Set log level
ALTER DYNAMIC TABLE MYDB.PUBLIC.DEBUG_SUMMARY SET LOG_LEVEL = 'DEBUG';

--changeset examples:unset-log-level
-- Unset log level
ALTER DYNAMIC TABLE MYDB.PUBLIC.DEBUG_SUMMARY UNSET LOG_LEVEL;

alterDynamicTable alterLogLevel

Available attributes

alterLogLevel nested attributes

XML

JSON

YAML

SQL

More like this