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.

25222522

The Join tab interface with a WHERE clause added

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.

  1. FROM
  2. WHERE
  3. GROUP BY
  4. HAVING
  5. WINDOW
  6. QUALIFY
  7. ORDER BY
  8. LIMIT

Generate Join

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.


Did this page help you?