Joins in Datameer
Watch this short demo to see how to JOIN in Datameer. Inner, outer, left, or a right join.
JOINS
Joining or merging data can be daunting to the casual data user. You typically need to understand SQL notation and understand the different types of join behavior.
Knowing the difference between inner, left, outer, and full outer join is essential to obtaining the correct results in your data.
Say hello to Datameer.
- We can explore and transform our Snowflake data in an easy-to-use user interface. We can see a data preview of the data tables that we want to join, allowing us to identify standard fields quickly.
- By selecting the join recipe, we can visualize how our data sources will look by selecting our data sources to join across.
- Datameer intelligence scans each dataset and tries to identify common fields to join with an associated degree of certainty.
- You can select which columns to join against and see an instant preview of how that data will be joined; You can choose different join modes to see how each join type affects your data.
- Using this visual approach to join data, you can quickly understand how your data is transformed without the need to write and understand SQL join syntax; it's that easy.
- Once you're happy with your join, you can select the apply button, which will add your newly created join to your project in the form of a recipe in which further transformations can be applied
- Once I transform my data, I can publish my newly transformed data back onto Snowflake in the form of a view or a materialized table.