Skip to main content

Join Tab

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. The JOIN tab is part of the Node Editor.

The Join tab allows users to write SQL that will refine the results plus include additional sources through JOINs. All SQL operators are supported, though SELECT statements are uncommon, as SELECTing is effectively done by the mapping grid. The JOIN tab is part of the Node Editor.

Snowflake

This functionality follows Snowflake SQL standards.

he 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.