Create your first transform

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 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 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 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 coming soon coming soon