Lakehouse
Features
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.
PartitioningPartition Altertable catalog tables by column or transform to improve write layout and query pruning.Sorted tablesConfigure a physical sort order on Altertable catalog tables to improve min/max statistics and query pruning.TransactionsRun ACID transactions against Altertable catalogs with snapshot isolation and all-or-nothing semantics.Time travelQuery Altertable catalog tables as of earlier snapshots using version or timestamp bounds for audits and reproducible reports.ViewsCreate, store, and query SQL views in Altertable catalog metadata so teams can reuse governed lakehouse logic.MacrosDefine reusable scalar and table macros in Altertable catalog metadata with standard CREATE MACRO syntax.Data change feedQuery inserts, updates, and deletes between catalog snapshots using table_changes and related functions.Full-text searchSearch text across Altertable tables with SQL-native full-text search for faster discovery across lakehouse data.Optimize tableOptimize Altertable tables for better storage layout, faster queries, and improved lakehouse performance at scale.MATCH_RECOGNIZEFind ordered row patterns such as funnels, journeys, and state transitions with SQL:2016-style MATCH_RECOGNIZE.SESSIONIZEAssign ordered events to gap-based sessions and calculate session-level measures with DuckDB SQL in Altertable.