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…
Ever wanted to find a quick way to increase your match rate when unifying your data? I recently came across a cool way to use text analysis to do just that. Check it out! I started with a query on my tag list (using SQL transformation), to count the frequency of all the different words in my tag description field: SELECT…
