horizon.tech

Using Table Schemas

You can apply table schemas to enforce rules around data, set data types and default values, and more.

Table schemas can be either created or inferred. If you already have data attached or uploaded and associated with a table, you can infer a schema. Schema Inference will scan all data associated with a table and extract fields. Otherwise you create a schema and add fields.

When you create a schema you're able to generate and restrict data in the table like a data model for a relational database. You can specify uniqueness guarantees, allow (or restrict) subsets and supersets of the schema in the data. For example, if you set the superset schema to allowed, data can have fields not currently in the schema. If you set the subset schema, or required fields, you can have data which doesn't require specific fields.

Finally, you can set data types and defaults, including relations to other layers. With schema defaults, any time a data point is created defaults will be set.

modifying a schema. Set uniqueness, superset, subset, default data, data types.

horizon.tech

A low-code platform for data collection, schema management, data visualization, and publishing.

© 2024 - 2025 Yrbia LLC, Delaware. All rights reserved.