Skip to main content
The Destination tool is used to send data outside of Less. That could be to databases like Snowflake, send emails with Gmail, or to a Microsoft Sharepoint.
When using the Destination tool, your table is not stored in Less. It is sent to the destination you have selected.
Before using the Destination tool, you need to create a destination. You can learn more about that here Destinations. The Destination tool works by referencing the destination that you already created. That means you don’t have to log in or authenticate, but simply select the destination you want to use and fill in a couple of fields (such as a table name for databases). As a result, each Destination tool differs by the type of destination you want to use (e.g. Snowflak, Gmail, Microsoft Sharepoint). We’ll add documentation as we add new destinations types below.
1

Output table name

This input supports parameter syntax
Select the table name that you want to create in Snowflake. If you are appending or upserting, you need to specify a table name that already exists in Snowflake.
2

Operation

  1. Overwrite. This will overwrite the existing table with the new data every time the Destination tool runs.
  2. Append. This will add all the new rows to the existing table. Over time there’s a risk that you will create very large tables - use this option with caution.
  3. Upsert. This requires selecting a column to use as a unique identifier. The upsert operation will then look for that ID in the table and update the existing rows with the new data (when it finds a row with that ID). If the row does not exist, it will insert a new row.
3

Upsert Column (only for upsert operation)

Select the column that you want to use to upsert the data. You need to ensure that this column exists in the table you are upserting to.