On the Transformation page, go to the Code Editor tab. You will see that the new Transformation already has the first Operation with the SQL code
Write your custom SQL code in the editor.
The entered SQL code undergoes validation to ensure that the query can be executed when the Transformation is run. If there are any errors during the validation process, you will see them in the top toolbar above the code. In this article, you can see some examples of common errors that can occur during SQL query validation.
When the code validation is successfully passed, you will see a green mark that says "Valid SQL code".
You can create multiple Operations in one Transformation by clicking the "+" button in the Operations section in the sidebar.
By default, all new Operations have a "SELECT 1" query. Change it for your needs. And then don't forget to save all changes.