Create & Manage Transformations
To start creating Transformations or to view the already created transformations click on the Transformations link in the main tool bar as shown below.

Adding a new Transformation
Pre-requisites for creating Data Transformation
|
Step by Step Process
- Step 1
-
Enter a name for the transformation. Please choose a unique name and ensure the name has no spaces and special characters except for an Underscore (_).
- Step 2
-
Choose the Data Warehouse where you would want the transformation script to run. Go to Data Warehouses if you do not find your destination here and add a new data warehouse as explained here
- Step 3
-
Type in the SQL query or script you would want to execute. In case of multiple SQL statements in the script ensure each statement is terminated by a semi-colon(;)
DataChannel does not parse the SQL query for logical or semantic correctness and just executes the provided SQL script on the schedule. Please check the SQL scripts carefully before configuring the transformations.

- Step 4
-
Choose dependencies if you would want your transformation to run only when a data pipeline has successfully executed.
- Step 5
-
Select a schedule for the pipeline if needed and click on Save button to save this transformation.
Still have Questions?
We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.
Subscribe to our Newsletter for latest updates at DataChannel.