> For the complete documentation index, see [llms.txt](https://docs.infotopics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.infotopics.com/trulyp/data/semantic-modeling.md).
# Semantic modeling
The Semantic Model page lets you define a semantic model. Semantic models can be used by Trulyp for Analytics or act as a datasource for SuperTables.
***
### How it works
1. Under data, go to Semantic models, and click **Create new semantic model.**
2. Fill in the name and description, and then select if you want to make a connection-backed model or import one from a semantic provider.
> What is the difference between a connection-backed model and an imported semantic provider model?
>
> * A connection-backed model is built from one of your database connections. You choose which tables to include in the semantic model.
> * A semantic provider model is imported directly from a provider, for example Tableau VDS.
{% tabs %}
{% tab title="First Tab" %}
To use a connection-backed model, select your connection on the left. Your available tables will now show up. Filter or scroll to find the table you want to use, and then click on it to add it to the model.
When you have done this, you will see that the "semantic profile" is generated, which allows you to review field meanings.
If you are happy with the semantic model, click **Save semantic model** in the top right.
After saving it, you can preview the data in the semantic model in the **Data preview** section:
#### Caching (Only for connection based models)
When using large datasets (e.g. > 10000 rows) Trulyp applies caching to totals and grand totals to avoid querying the database every time. Supertables already has a mechanism built in to update the totals and grand totals whenever it detects that data has changed. In specific use cases it would be beneficial to refresh the data more often. In this case
{% endtab %}
{% tab title="Semantic provider import" %}
### Semantic provider import
Before you set up an imported semantic provider model, add a semantic provider to your Trulyp environment. Follow [Semantic providers](/trulyp/data/semantic-providers.md).
Once that is set up, follow these steps:
1. Choose **Semantic provider import** as the model source.
2. Select the semantic provider you configured.
3. In **Datasource**, select one of the available data sources from that provider.
4. After you select a data source, the model shows its tables and relationships.
5. To change the model, update it at the semantic provider, this is not possible in Trulyp. After making your desired changes, re-import the model into Trulyp.
{% endtab %}
{% endtabs %}
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.infotopics.com/trulyp/data/semantic-modeling.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
