---
title: Create your first transform
slug: create-your-first-transform
docTags: 
createdAt: 2022-10-19T21:33:16.000Z
---

# Transforms can be SQL or low code

A `Transform` is where you define your data operations. 

To create a new `Transform`:

- In the `Home page` or on the side bar, click on `Transforms`
- Then click on the "+" button in the top right-hand corner
- Please enter the name of your `Transform`, for example, `Sales_clean`
- Choose the type of transform between `Staging`, `Intermediary` and `Marts`

![](https://api.archbee.com/api/optimize/RcoaF_HrCocAsEWeokbtP/NOrB0ZLN_f7c6AcvRsSjF_addtransform.gif)

:::hint{type="info"}
**How to choose betwenn Staging, Intermediary and Marts?**

`Staging` is for transforms that perform simple operations from raw data (like drop columns, cast columns, etc.)

`Intermediary` is for transforms that perform logic operations but where result tables are not to be shared with business users

`Marts` are for transform where result tables are to be shared with business users.
:::

***

# Transform with SQL

You can write SQL in the code editor, then hit the `Run` button and see the results.

### Insert table names

On the left panel, you can see all the tables from your Data Warehouse. Simply navigate in your Data Warehouse, or search for a table, and hit the arrow on the right. This will insert the table name.

![](https://api.archbee.com/api/optimize/RcoaF_HrCocAsEWeokbtP/K214nZDcnhQMKedZASpwz_inserttable.gif)

### Insert columns names

On the left panel, you can see all the columns for a table. Simply use the arrow to insert all columns names. 

![](https://api.archbee.com/api/optimize/RcoaF_HrCocAsEWeokbtP/UySXx0i9RtqcDQ35zBHto_insertcolumns.gif)

:::hint{type="success"}
**Tip: **If you filter the columns with the filter box, then use the arrow, it will insert only the filtered columns. This can be super useful!
:::

### Save your query

Running your query only shows you the result. Once you're happy with your query, click on the `Save` button. This will effectively add your `Transform` in your pipelines.

***

# Transform with low code   <font color="#eb144c">`coming soon` </font>``