The Join tab allows users to write SQL that will refine the results and/or include additional sources to add via JOINs. All Snowflake SQL operators are supported, though SELECT statements are uncommon, as SELECTing is effectively done by the mapping grid.
Typically, a Snowflake SQL SELECT statement’s clauses are evaluated in the order shown below, which can be helpful when structuring the contents of the Join tab.
- GROUP BY
- ORDER BY
Clicking this link will open a small modal with an automatically generated FROM statement that includes the Source Node used in the current node. If more than one Source Node was used, it will attempt to generate an INNER JOIN statement where you can configure which columns the JOIN will use. If you want to combine multiple sources without a JOIN, refer to our Multi Source Nodes feature instead.
Using Ref Functions
You must use Ref Functions to refer to nodes here, otherwise you may find unexpected behavior.
Copy to Clipboard
Copies the generated SQL statement to your operating system's clipboard.
Copy to Editor
Copies the generated SQL statement to the text box in the Join tab. Note that this will not erase the current contents of the text box, and will append to the existing text instead.
Updated 6 months ago