---
title: "Set up modeling transformation"
slug: "set-up-modeling-transformation"
tags: ["Task", "Data Modeling Studio", "DMS"]
updated: 2026-03-20T11:27:36Z
published: 2026-03-20T17:44:45Z
canonical: "docs.staedean.com/set-up-modeling-transformation"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.staedean.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Set up modeling transformation

On deploy of a data model, you can use modeling transformations to create views in the target database. These views are created based on the business entities that are created in the target database on deploy. A modeling transformation contains one or several SQL statements which define the transformation actions to be done.

Usually, a transformation is created in SQL and then the file is uploaded to the **Data templates and transformations**. On upload, a new transformation is created or an existing transformation is overwritten. You can also manually create a transformation in Data Modeling Studio and create or copy the SQL statements to the **Definition** field.

### Steps

1. Go to **Data modeling studio** > **Data modeling studio** > **Data templates and transformations**.
2. Sub-task: Upload modeling transformation.
  1. Click **Upload**.
  2. On the dialog, browse for and select the desired compressed (zipped) folder or single modeling transformation file.

Click **Upload**.

> [!NOTE]
> **Note**
> 
> If you select a compressed (zipped) folder with several data templates and transformations, all these data templates and transformations are considered for upload.
  3. If a data template or transformation:

Click the desired action: '**Yes**' or '**No**'.
    - Does not exist, it is created.
    - Already exists, you get a message to indicate if it must be overwritten or not.
  4. On the **Data templates and transformations** page, in the list, find and select the uploaded transformation.
  5. Click **Edit**.
  6. In the **Description** field, type or edit the description.
  7. In the **Category** field, select '**Modeling**'.
3. Sub-task: Create modeling transformation.
  1. On the **Data templates and transformations** page, click **New**.
  2. In the **Template** field, type a value.
  3. In the **Description** field, type a value.
  4. In the **Category** field, select '**Modeling**'.
  5. In the **Type** field, select '**T-SQL**'.
  6. Expand the **Definition** section.
  7. In the **Definition** field, create or copy the desired SQL statements.
4. Close the page.

> [!NOTE]
> **Notes**
> 
> In the SQL statements, you can use variables. On deploy, these variables are replaced with a value. You can use these variables:
> 
> - **$MODEL$**: Is replaced with the name of the deployed data model.
> - **$SCHEMA$**: Is replaced with schema name as defined for the deployed data model.
> - **$EXECUTIONID$**: Is replaced with the execution GUID that is assigned to the deployment of the data model.

## Related

- [Set up transformations](/set-up-transformations.md)