Familiarisation with the User Interface

Transformations

Overview

This section will help to familiarize you with the layout on the Transformations page of the DataChannel Console. There could be scenarios where you need to perform certain transformations on your data. Using transformations, you can write complex SQL queries to perform useful operations on your data. The Transformations Tab allows you to set up new transformations and edit existing ones.

transformations page
  1. You can access the Transformations page by clicking on the Transformations Tab which lies at the center of the sidebar, right below the Data Warehouses Tab.

  2. The search box, located below the Top Banner, inside the Transformations page allows you to quickly find a specific transformation created by you.

  3. The Rows per page dropdown located on the top right part of the Main UI Screen allows you to select the number of rows visible on one page of the Transformations List pane.

  4. The Transformations List pane displays the details of all the transformations created by you.

  5. Navigating between different pages of the Transformations List pane is possible through the page numbers on the navigation bar, near the bottom right corner of the pane.

  6. The Create New button, located below the Top Banner, on the top right corner of the Main UI Screen, allows you to create a new transformation for applying to your Data.

Creating a New Transformation

  1. Go to the Transformations page and click on the Create New button to create a new transformation for applying to your data in the data warehouse. Make sure that you have added a data warehouse before attempting to create a Transformation.

  2. In the fields that appear on the screen, give a name to the transformation and add a Data Warehouse. Key in the SQL Query that you wish to execute and choose a schedule to run the transformation. Lastly, don’t forget to click the Save changes button.

transformations page2

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.