Reference
Version · 6.0
Change Automation Reference

Alter Dynamic Table - Overview

Last updated: August 12, 2026

Alters properties of an existing dynamic table in Snowflake. Dynamic tables are materialized views that automatically refresh based on changes to underlying data.

Known limitation: 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 alter if the table exists using `IF EXISTS`	No

Available Operations

Specify one or more nested elements to perform different alter operations. Multiple operations can be combined in a single change.

Table Management

renameTo - Rename the dynamic table or move it to a different schema/catalog
swapWith - Swap the dynamic table with another dynamic table

State Control

alterState - Suspend, resume, or manually refresh the dynamic table

Refresh Configuration

alterTargetLag - Modify the target lag for automatic refreshes
alterWarehouse - Change the warehouse used for refresh operations

Performance Optimization

alterClustering - Modify clustering key configuration

Data Retention

alterDataRetention - Modify data retention settings for Time Travel

Metadata and Configuration

alterComment - Update or remove table comment
alterCollation - Modify default DDL collation
alterLogLevel - Modify the log level for the dynamic table
alterImmutableWhere - Modify the immutable WHERE clause

Governance

alterTags - Add or remove tag associations

Security Policies

alterRowAccessPolicy - Modify row-level security policy
alterAggregationPolicy - Modify aggregation policy

<?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">

    <!-- Multiple operations in a single change -->
    <changeSet id="comprehensive-alter-dynamic" author="examples">
        <pro-snowflake:alterDynamicTable tableName="SALES_SUMMARY" ifExists="true">
            <!-- Update comment -->
            <pro-snowflake:alterComment newComment="Updated sales summary with optimized settings"/>

            <!-- Adjust target lag for more frequent updates -->
            <pro-snowflake:alterTargetLag newTargetLag="5 MINUTES"/>

            <!-- Modify clustering for better performance -->
            <pro-snowflake:alterClustering clusterBy="SALE_DATE, REGION"/>

            <!-- Update data retention -->
            <pro-snowflake:alterDataRetention
                newDataRetentionTimeInDays="60"
                newMaxDataExtensionTimeInDays="14"/>

            <!-- Add governance tags -->
            <pro-snowflake:alterTags>
                <pro-snowflake:setTags>
                    <pro-snowflake:entry key="environment" value="production"/>
                    <pro-snowflake:entry key="data_classification" value="confidential"/>
                </pro-snowflake:setTags>
            </pro-snowflake:alterTags>

            <!-- Add row access policy -->
            <pro-snowflake:alterRowAccessPolicy
                policyName="SALES_ACCESS_POLICY"
                on="REGION"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "comprehensive-alter-dynamic",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "SALES_SUMMARY",
              "ifExists": true,
              "alterComment": {
                "newComment": "Updated sales summary with optimized settings"
              },
              "alterTargetLag": {
                "newTargetLag": "5 MINUTES"
              },
              "alterClustering": {
                "clusterBy": "SALE_DATE, REGION"
              },
              "alterDataRetention": {
                "newDataRetentionTimeInDays": 60,
                "newMaxDataExtensionTimeInDays": 14
              },
              "alterTags": {
                "setTags": {
                  "entries": [
                    {"entry": {"key": "environment", "value": "production"}},
                    {"entry": {"key": "data_classification", "value": "confidential"}}
                  ]
                }
              },
              "alterRowAccessPolicy": {
                "policyName": "SALES_ACCESS_POLICY",
                "on": "REGION"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: comprehensive-alter-dynamic
      author: examples
      changes:
        - alterDynamicTable:
            tableName: SALES_SUMMARY
            ifExists: true
            alterComment:
              newComment: Updated sales summary with optimized settings
            alterTargetLag:
              newTargetLag: "5 MINUTES"
            alterClustering:
              clusterBy: "SALE_DATE, REGION"
            alterDataRetention:
              newDataRetentionTimeInDays: 60
              newMaxDataExtensionTimeInDays: 14
            alterTags:
              setTags:
                entries:
                  - entry:
                      key: environment
                      value: production
                  - entry:
                      key: data_classification
                      value: confidential
            alterRowAccessPolicy:
              policyName: SALES_ACCESS_POLICY
              on: REGION

<?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">

    <!-- Multiple operations in a single change -->
    <changeSet id="comprehensive-alter-dynamic" author="examples">
        <pro-snowflake:alterDynamicTable tableName="SALES_SUMMARY" ifExists="true">
            <!-- Update comment -->
            <pro-snowflake:alterComment newComment="Updated sales summary with optimized settings"/>

            <!-- Adjust target lag for more frequent updates -->
            <pro-snowflake:alterTargetLag newTargetLag="5 MINUTES"/>

            <!-- Modify clustering for better performance -->
            <pro-snowflake:alterClustering clusterBy="SALE_DATE, REGION"/>

            <!-- Update data retention -->
            <pro-snowflake:alterDataRetention
                newDataRetentionTimeInDays="60"
                newMaxDataExtensionTimeInDays="14"/>

            <!-- Add governance tags -->
            <pro-snowflake:alterTags>
                <pro-snowflake:setTags>
                    <pro-snowflake:entry key="environment" value="production"/>
                    <pro-snowflake:entry key="data_classification" value="confidential"/>
                </pro-snowflake:setTags>
            </pro-snowflake:alterTags>

            <!-- Add row access policy -->
            <pro-snowflake:alterRowAccessPolicy
                policyName="SALES_ACCESS_POLICY"
                on="REGION"/>
        </pro-snowflake:alterDynamicTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "comprehensive-alter-dynamic",
        "author": "examples",
        "changes": [
          {
            "alterDynamicTable": {
              "tableName": "SALES_SUMMARY",
              "ifExists": true,
              "alterComment": {
                "newComment": "Updated sales summary with optimized settings"
              },
              "alterTargetLag": {
                "newTargetLag": "5 MINUTES"
              },
              "alterClustering": {
                "clusterBy": "SALE_DATE, REGION"
              },
              "alterDataRetention": {
                "newDataRetentionTimeInDays": 60,
                "newMaxDataExtensionTimeInDays": 14
              },
              "alterTags": {
                "setTags": {
                  "entries": [
                    {"entry": {"key": "environment", "value": "production"}},
                    {"entry": {"key": "data_classification", "value": "confidential"}}
                  ]
                }
              },
              "alterRowAccessPolicy": {
                "policyName": "SALES_ACCESS_POLICY",
                "on": "REGION"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: comprehensive-alter-dynamic
      author: examples
      changes:
        - alterDynamicTable:
            tableName: SALES_SUMMARY
            ifExists: true
            alterComment:
              newComment: Updated sales summary with optimized settings
            alterTargetLag:
              newTargetLag: "5 MINUTES"
            alterClustering:
              clusterBy: "SALE_DATE, REGION"
            alterDataRetention:
              newDataRetentionTimeInDays: 60
              newMaxDataExtensionTimeInDays: 14
            alterTags:
              setTags:
                entries:
                  - entry:
                      key: environment
                      value: production
                  - entry:
                      key: data_classification
                      value: confidential
            alterRowAccessPolicy:
              policyName: SALES_ACCESS_POLICY
              on: REGION

PreviousAlterDatabaseTags NextAlter dynamic table - clustering