How to: Use the Formula Builder

Goal

How to transform data using a no-code constructor that supports native Snowflake functions.

Solution

1. Add a Data Source to the Project. How to add a Data Source.
2. Click on the "+" next to a dataset to open the available action list.
3. Choose Formula Builder.
   
4. Choose the column whereto apply a formula. 
5. Type the formula in format <function>(Source.<column name>) and press Apply Formula button.
   
   
   
   
6. Another option is to create a new column and add a formula there.
7. Expressions that contain several functions are supported as well.
   
   
   
   
8. When all the formulas are introduced, press the Apply button at the top right corner to save the transformation as a new View.