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.

transformations 1

Adding a new Transformation

Pre-requisites for creating Data Transformation

  • The Data Warehouse where you intend to execute the transformation should be added to your account, Click here to learn how.

  • Keep the SQL Script you wish to execute as part of the transformation ready. Please test the script thoroughly to ensure it works as required.

  • Ensure the user configured as part of the Data Warehouse connection has the requisite rights to run the script on the destination.

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 (_).

transformations add 1
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

transformations add 2
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.
transformations add 3
Step 4

Choose dependencies if you would want your transformation to run only when a data pipeline has successfully executed.

transformations add 4
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.