---
title: "Set up instrumentation transformation"
slug: "set-up-instrumentation-transformation"
tags: ["Task", "Data Modeling Studio", "DMS"]
updated: 2026-03-20T11:27:40Z
published: 2026-03-20T17:44:45Z
canonical: "docs.staedean.com/set-up-instrumentation-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 instrumentation transformation

On deploy of a data model, you can use instrumentation transformations to create objects, stored procedures, and schemas in the target database. You can also use these transformations to do calculations on the metadata that is exported on deploy. An instrumentation 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 instrumentation transformation.
  1. Click **Upload**.

On the dialog, browse for and select the desired compressed (zipped) folder or single instrumentation transformation file.
  2. 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 '**Instrumentation**'.
3. Sub-task: Create instrumentation 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 '**Instrumentation**'.
  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)