Features
Altertable catalog tables support capabilities that shape how data is written, queried, and maintained over time. Use these features when you need predictable scan performance, historical reads, reusable logic, or incremental downstream processing.
Partitioning and sorted tables improve write layout and query pruning. Time travel and views help you inspect history and encapsulate logic. Data change feeds, macros, and optimize-table support operational pipelines and housekeeping.
Partitioning
Partition Altertable catalog tables by column or transform to improve write layout and query pruning.Sorted tables
Configure a physical sort order on Altertable catalog tables to improve min/max statistics and query pruning.Transactions
Run ACID transactions against Altertable catalogs with snapshot isolation and all-or-nothing semantics.Time travel
Query Altertable catalog tables as of earlier snapshots using version or timestamp bounds for audits and reproducible reports.Views
Create and query views stored in Altertable catalog metadata using standard SQL syntax.Macros
Define reusable scalar and table macros in Altertable catalog metadata with standard CREATE MACRO syntax.Data change feed
Query inserts, updates, and deletes between catalog snapshots using table_changes and related functions.Full-text search
Search text in Altertable tables.Optimize table
Optimize Altertable tables for storage and query performance.