Alter Dynamic Table - Overview
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