How-to guides

The Quickstart covers installation and a first query. Each guide below addresses one task and stands on its own.

• Set up RollUps — pre-compute aggregations so dashboards don't re-scan raw data; cascade refreshes through a dependency DAG.
• Last Value Cache — sub-10ms reads for status widgets and "current value" tiles.
• Bulk ingest — write batches from edge devices, protocol adapters, or other writers using the JSONB ingest function.
• Alerts — SQL-native threshold and deadman alerts that run inside Lakebase.
• Data lifecycle — add tiering, retention, and tiered retention policies so old data tiers to Unity Catalog and eventually drops.
• Monitoring — query operational metrics, chunk health, and top queries from inside Lakebase.
• Manage tag cardinality — track distinct tag values to prevent label explosion in multi-metric ChronoTables.
• Sync to Unity Catalog — expose RollUp Tables to Spark, BI, and ML pipelines via Lakebase CDF.

For the internals behind any of these, see How It Works. For full function signatures, see the Reference.