Unify provides various built-in transformations to transform data into a more usable/context-rich format. Among those transformations is the SQL query where you can perform more advanced/flexible operation on the data. Today, I'm sharing a cheat sheet of the most commonly used SQL queries that our team and customers have…
A recent Element Unify update addresses an issue with how special columns are handled by SQL Query, SQL Join, and Union transformations. This fix prevents unexpected behavior when building graphs but may affect some pipelines that were built before it was deployed. If you see an error like "<Column Name> has conflicting…
Audit transformation Lets the user make changes to a pipeline flow in a table format, the user needs to base these changes on a column that has unique values. The unique values will help identify which rows will be edited. The user can also see what edits have been done to the given flow, these edits can be undone under…
Would be nice to be able to draw a box or section out part of the pipeline and put some labels or documentation on it.
It would be a great functionality, for when the user drags the flow line into the canvas, not to a transformation, a menu with all available transformation will be open. once the user selects the transformation to be added, the flow is connected to the selected transformation