📄️ What are Hypertables
Hypertables are composable data products you can assemble easily from a variety of data sources. Mix-and-match, share and amplify the power of data. They support two modes, “Live” where the underlying data sources are queried live, making Hypertables perform federated live querying. The other mode they support is “Scheduled”, in which they operate more like materialised views where their backing table is refreshed incrementally with new data from their configured data sources.
📄️ Hypertable Types
Scheduled Hypertables
📄️ Snapshots and Time Travel
Scheduled Hypertables are stored in Z-Lake and feature snapshots. A snapshot is a point-in-time representation of a table's data and metadata. It captures a consistent view of the table's contents, including all updates, deletions, and additions made since the last snapshot. When a new snapshot is created, only the changed data is written to the storage layer, allowing for efficient incremental updates. This incremental snapshotting approach also enables fast, low-cost data restoration in the event of a failure or accidental data loss. 
📄️ Querying Hypertables
Hypertables are accessed like any SQL table or view. There are some rules though. While referring to a Hypertable in a SQL query, always prefix the hypertable name with hypertables.default for live Hypertables and hypertables.scheduled for scheduled Hypertables.
📄️ Quick Create Sched Hypertables
If you need to create a Hypertable to just mirror a table in the data source, you can quickly create a scheduled Hypertable.
📄️ Setting Up Sched Hypertables
Setting up a scheduled HyperTable requires setting up a “data transform” and scheduling it at a particular time or interval.
📄️ Connecting to External BI Tools
Ways to connect
📄️ Connecting to DBeaver
Work with SQL in the comfort of a desktop SQL editor, easily connecting to your Zipstack cluster