Peliqan automatically stores and tracks metadata of your data assets. This page provides an overview of common types of metadata, how to expose your Data Model (including metadata) to e.g. AI Agents and how to build up a Semantic model.

Metadata

Primary keys

Peliqan automatically detects primary keys (PK’s) in every table. However, you can change the PK for each table (including queries) by going to the table in the Grid view, click on Details and next click on “Edit” in the top menu bar:

Foreign keys (relations)

You can manually set a relation on a column. In the Grid view, click on a column header and select “Edit field” from the menu. Choose the column type “Link to table” and set the related table:

Peliqan also provides a template app that can automatically detect relations between tables. In Peliqan go to the Build section (apps) and click on the template “Detect FKs (ERD relations)” to install it in your account:

Table descriptions

You can document the meaning of tables in a dataset, by adding a description to each table. Click on “Details” in the top menu above a table in the Grid view to edit the metadata of the table, including the description:

Column descriptions

You can document the meaning of columns per table, by adding a description to each column. Click on a column header in the Grid view, and select Show details from the menu. You will now be able to set a description to the column, as well as a background color and icon:

Data models

Peliqan allows you to build up business-ready data models from your raw data, which was landed in the data warehouse by the ELT pipelines. Depending on the use case, you might want to use a Medallion data model, build up a Star Schema, use the Data Vault modeling technique or simply write views that translate raw data into understandable tables.

Data models are built up by writing SQL queries (views) in Peliqan. More info:

Peliqan will automatically keep track of the lineage of your queries. More info:

You can make your data model available to e.g. AI agents that need to perform text-to-SQL. Peliqan provides a template of an API handler script that allows you to generate and publish your data model, including relevant metadata. In Peliqan go to the Build section (apps) and click on the template to install it in your account:

Semantic model

A semantic model is built up in Peliqan by combining all of the above features, in order to provide context to a dataset. This means building up a business-ready dataset, adding documentation (descriptions on tables and columns), defining relations and publishing the datamodel as e.g. an API endpoint for consumption.

Existing semantic models (e.g. Yaml files) can be imported using a script in Peliqan, so that the metadata (descriptions etc.) are available in Peliqan.

See also how to retrieve and update metadata in Peliqan from scripts: