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, store, and query SQL views in Altertable catalog metadata so teams can reuse governed lakehouse logic.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 across Altertable tables with SQL-native full-text search for faster discovery across lakehouse data.Optimize table
Optimize Altertable tables for better storage layout, faster queries, and improved lakehouse performance at scale.