Familiarisation with the User Interface

Transformations

Overview

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

transformations menu options

Dbt™ Core

transformations page

  1. Go to the Transformations tab, right above the Warehouses Tab.

  2. You can access the dbt™ transformations page by clicking on the dbt™ Core option in the Transformations tab.

  3. The search box, located below the Top Banner, inside the dbt™ Core page allows you to quickly find a specific dbt™ core transformation created by you.

  4. 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 dbt™ transformation List pane.

  5. The dbt™ core transformation List pane displays a Table with the details of all the dbt™ transformation created by you.

  6. Navigating between different pages of the dbt™ transformation List pane is possible through the page numbers on the navigation bar, near the bottom right corner of the pane.

  7. 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 dbt™ transformation for applying to your Data in the Data Warehouse. You can learn how to create a new transformation here.

  8. The icons in the actions column of the Table allow you to Delete/Edit/Run a transformation.

SQL Tansformations

transformations page1

  1. Go to the Transformations tab, right above the Warehouses Tab.

  2. You can access the SQL transformations page by clicking on the SQL option in the Transformations tab.

  3. The search box, located below the Top Banner, inside the SQL transformations page allows you to quickly find a specific SQL transformations created by you.

  4. 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 SQL transformations List pane.

  5. The SQL transformations List pane displays a Table with the details of all the SQL transformations created by you.

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

  7. 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 SQL transformation for applying to your Data in the Data Warehouse. You can learn how to create a new transformation here.

  8. The icons in the actions column of the Table allow you to Delete/Edit/Run a SQL transformations.

Dbt™ Cloud

transformations page2

  1. Go to the Transformations tab, right above the Warehouses Tab.

  2. You can access the dbt™ transformations page by clicking on the dbt™ Cloud option in the Transformations tab.

  3. The search box, located below the Top Banner, inside the dbt™ Cloud page allows you to quickly find a specific dbt™ cloud transformation created by you.

  4. 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 dbt™ transformation List pane.

  5. The dbt™ cloud transformation List pane displays a Table with the details of all the dbt™ cloud transformation created by you.

  6. Navigating between different pages of the dbt™cloud transformation List pane is possible through the page numbers on the navigation bar, near the bottom right corner of the pane.

  7. 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 dbt™ cloud transformation for applying to your Data in the Data Warehouse. You can learn how to create a new transformation here.

  8. The icons in the actions column of the Table allow you to Delete/Edit/Run a 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.