> 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/features/management-console/semantic-modeling.md).

# Semantic modeling

Since version 6.0, WriteBackExtreme has evolved from a pure writeback engine into a data service that can also act as a data source for Supertables.

A semantic model, called a **datasource** in the editor, lets Supertables fetch its data through the WriteBackExtreme data engine instead of its own. On large datasets that is a noticeable difference in performance.

You reach it through **Data & AI Services › Semantic models**, and you need the **schema manager** role or an administrator account.

{% embed url="<https://www.youtube.com/watch?v=l3CmGKzLIXo>" %}

## The semantic models list

**Semantic models** lists what you have built, with the **Name**, **Description** and **# Tables** of each, and an **Open** action. **New semantic model** starts a new one.

## Build a datasource

{% stepper %}
{% step %}

### Name it

Under **Datasource details**, fill in a **Datasource name** — it is required — and optionally a **Description** of what the datasource holds, up to 255 characters.
{% endstep %}

{% step %}

### Pick a connection and a table

In **Model workspace**, choose a connection on the left and WriteBackExtreme loads its tables. Click a table to put it on the grid, and it shows a chip saying it is on the canvas.

{% hint style="info" %}
A semantic model currently holds one table. Add a second and WriteBackExtreme tells you that only one table can be placed on the canvas for now.
{% endhint %}
{% endstep %}

{% step %}

### Configure the table and its columns

Select the table on the canvas and **Table configuration** opens on the right, with its name, connection and row count. **Force refresh row count** recounts the rows when the table has changed underneath you.

Give the table an **Alias** — a friendly name for the people who use it — and a **Description**.

**Data preview** shows the columns. Click the pencil on a column to set its **Alias**, add a **Comment**, or mark it **Hidden** so it does not reach Supertables at all. **Reset alias** puts the original name back.
{% endstep %}

{% step %}

### Save

Click **Save**. The datasource now appears in the list, and in Supertables you can select it as a data source when you configure the extension.
{% endstep %}
{% endstepper %}

{% hint style="warning" %}
**Delete** removes the datasource and cannot be undone. Any Supertables configuration pointing at it stops fetching data.
{% endhint %}

## Caching

On large datasets, WriteBackExtreme caches totals and grand totals rather than querying the database for them every time. Supertables refreshes those by itself when it detects the data has changed, so in normal use there is nothing to configure — there is no caching setting in the management console.

How much data is fetched per request is set by **Chunk size** in **Advanced settings**.


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.infotopics.com/features/management-console/semantic-modeling.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
