SQL Transformations
3min
Transformations allow logic to be executed against a target connection based on a scheduled frequency or triggered event of new data on tables updated via DataLakeHouse.io (DLH.io):
- Add a Transformation
- Pre-SQL Transformations
- Click on Transformation from the header menu
- Click on New Transformation or Add a Transformation to show the Transformation creation form.
- Update the form and determine what options to select.
Adding a new transformation, be sure to complete all the required details
Add a New Transformation
Pre-SQL transformations are unique to DLH.io where provide the ability to reference the in stream data (data streaming per each synchronization frequency) against the existing raw data landing zone.
This is a perfect use case for conceptual ideas such as refunds, chargebacks, employee punches, etc.
This option is available by selecting the Transformation Type in the transformation area.
See also Employee Pay Summary for example of using Pre-SQL logic.
Updated 25 Mar 2024
Did this page help you?