Function reference
Every LakeTS function, custom aggregate, trigger, and metadata table — grouped by what it does. All objects live in the lakets schema.
By topic
Core data model
- ChronoTables — create, manage, list, drop time-partitioned tables
- Multi-metric tables — tag + field model + cardinality controls
- Metadata tables — the
laketsschema's state-management tables
Query
- Time-series functions —
time_bucket,first,last,locf,interpolate,delta,rate,gap-fill,histogram
Aggregation
- RollUps — incremental aggregation engine + scale optimizations
Lifecycle
- Lifecycle policies — tiering, retention
- Lakebase CDF — shadow-table sync to Unity Catalog (ChronoTables and RollUps)
Operations
- Last Value Cache — sub-10 ms current-state reads
- Alerts — SQL-native threshold and deadman alerts
- Bulk ingest — JSONB batch + Prometheus-format ingest
- Monitoring — operational metrics and chunk health
- Workflow jobs — the Databricks Jobs that drive the operational lifecycle
At a glance
| Module group | Functions | Aggregates | Triggers |
|---|---|---|---|
| ChronoTables (incl. multi-metric) | 9 | — | — |
| Time-series analytics | 7 | 2 | — |
| RollUps (engine + optimization) | 26 | — | 4 |
| Lifecycle (tiering + retention) | 11 | — | — |
| Lakebase CDF | 3 | — | 1 |
| Last Value Cache | 5 | — | 1 |
| Alerts | 2 | — | — |
| Bulk ingest | 2 | — | — |
| Monitoring | 3 | — | — |
| Schema utilities | 1 | — | — |
| Total | 69 | 2 | 6 |
All objects in the lakets schema. PostgreSQL 17+ required (Lakebase default). No custom extensions.