Select DISTINCT Values
There a few ways you can load DISTINCT data into Coalesce.
View Node Type
First load your data into a View node and select DISTINCT values. Then create your Stage or Persistent stage from the View node.
View Nodes
The View Node Type is disabled by default, but can be enabled in your Build Settings > Node Types.
![Toggle DISTINCT to only have unique values](https://files.readme.io/6a6df5b-distinct_load_view_2024_May_2.png)
Toggle DISTINCT to only have unique values
GROUP BY ALL Clause in Join
If you want to use an existing Node Type like a Stage or another Node Type that doesn't offer the DISTINCT toggle, you can add a "GROUP BY ALL" clause in the Join tab of the Node Editor, which achieves the same behavior and, due to the way Snowflake operates, performance as DISTINCT.
![](https://files.readme.io/f55080e-GROUP_BY_ALL_DISTINCT.png)
Create a Custom Node Type With SELECT DISTINCT Behavior
If you wish to have a Node Type with this functionality built in so you can use it for many Nodes without having to complete one of the approaches detailed above, you can duplicate an existing Node Type and and edit the Create Template (for View behavior) and the Run Template (for Table behavior) to include the DISTINCT keyword in the SELECT, so that it is automatically included for all Nodes of this new Node Type.
![DISTINCT in the Create Template](https://files.readme.io/978cb50-create_template_select_distinct.png)
DISTINCT in the Create Template
![DISTINCT Run Template](https://files.readme.io/f6b968a-run_template_distinct.png)
DISTINCT Run Template
Updated 26 days ago