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.

Once defined—irrespective of whether they are Live or Scheduled—they are managed in the same fashion. Hypertables turn data into data products by bringing in discoverability, observability, access control, transformation on top of any data. Hypertables can be built on top of other Hypertables. They can combine data from multiple sources (flat files, SaaS applications, SQL and NoSQL sources) seamlessly and present them as one coherent, well-managed, discoverable unit of data.

Hypertables build on aspects you are already familiar with. You can define and transform them using just SQL. Live Hypertables are defined simply as SQL Views that combine data from multiple sources irrespective of their type. Scheduled Hypertables are also built and transformed with just SQL. There’s no need to learn a new version of SQL since Zipstack leverages ANSI SQL.