We have recently added a new feature called 'Dependency Triggers' to our Transformation product. This feature empowers you to define dependencies between Transformations, granting you control over their execution by considering the successful completion of other Transformations, in addition to time-based triggers.
Today, we are excited to announce that these dependency connections are now displayed in the diagram on the Workspace page, making it even more valuable for our users. This new feature enables data analysts to create sequential data processing workflows using a streamlined and visual approach. It simplifies the process of preparing data specifically for building marketing reports.
How it works
For instance, let's create four custom Transformations that need to be executed in a specific sequence. To add more complexity, let's configure the third Transformation to run only after the successful completion of the first and second Transformations. To establish this dependency, we will employ Dependency triggers within each Transformation.
For Transformation "Step 3":
For Transformation "Step 4":
The resulting diagram will display the following structure:
Subsequently, we will incorporate SQL code within each Transformation to process the data. This will lead to the appearance of Data storage nodes on the diagram.
For more details about the Workspace functionality, you can refer to this article. Additionally, we have provided a comprehensive guide with three easy onboarding steps on how to build your own solution from scratch.
Your feedback is invaluable to us, so please don't hesitate to reach out to us at firstname.lastname@example.org with any suggestions or concerns you may have.
Thank you for choosing OWOX BI as your marketing analytics partner.