Skip to main content

Models

Use this page to create, update, and delete models in Wren AI.

Models combine schema, metadata, relationships, calculated fields, and semantic context from your data source so both users and Wren AI can understand what each entity represents.

Soft Limitation

Each project in Wren AI supports up to 200 models (table) import by default. This is a soft limitation - you can increase this limit by contacting us.

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 list​

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

Create multiple models​

When adding models, there is a 30-second waiting period before you can add another one. After a model is added, Wren AI syncs metadata from the selected source after you choose tables and columns. This process applies to all data source types.

Remember to deploy your changes

Deploy​

If you make changes in the Modeling page, Wren AI shows a notice at the bottom of the page. Click Update Models Now to synchronize those changes.

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.