Skip to main content

Models

Models are a fundamental unit in Wren AI that combines schemas, metadata, relationships, calculated fields, and more custom semantic information from the tables of your data source. They help both people and Wren AI service better understand data.

Create a model​

Create a model from the connection process​

During the connection process, you are asked to select which tables you want to use in Wren AI.

These selected tables will automatically be created as data models.

tip

Wren AI allows connecting only the necessary tables from your sources. If you change your mind about which tables to connect and columns to sync, you can modify this in the project settings.

select_tables

Create a model from the Modeling page​

  1. Click the "+" icon next to the "Models" section of the sidebar.
  2. Select a table from your data source.
  3. Select the columns you want to add to this model, then click ">" to include them.
  4. Select the primary key of this table (optional).
  5. Click "Submit".

select_tables_modeling

Update model columns​

To update column settings in a model:

  1. Click the "..." icon on the model diagram.
  2. Choose "Update columns".

update_column_1

Update columns​

You can add or remove columns of this model.

update_column_2

Update primary key​

You can add or change the primary key of this model.

update_primary_key

Model lists​

You can access the list of models in the "Models" section of the sidebar on the Modeling page.

Click on the expand icon to see the columns in a model.

If you click on a model from the sidebar, the Entity Relationship diagram will focus on the model you clicked.

model_list

Delete a model​

To delete a model:

  1. Click the "..." icon on the model diagram.
  2. Choose "Delete".

delete_model

Creating multiple models at the same time​

When adding models, please note there's a 30-second waiting period before adding another. Once a model is added, data synchronization from the chosen source will begin after selecting tables and columns. This process applies to all data source types.

Remember to deploy your changes

Deploy​

If there is some changes in the modeling pages, you will see a notice at the bottom of your modeling page. Please press the "Update Models Now" button at to synchronize any modifications in the Modeling page.

Undeployed changes detected message will only display, when there is any new changes.

undeployed

When deploying... it will show message as below deploying

After the status changes from 'Deploying...' to 'Synced', the notice section will disappear after one second. deployed

info

The project owners will be notified of new changes to the model once they are completed.