> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Destination

> Store tables

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.

<Info>
  When using the Destination tool, your table is **not** stored in Less. It is sent to the destination you have selected.
</Info>

Before using the Destination tool, you need to create a destination. You can learn more about that here [Destinations](/destinations/quickstart).

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.

<AccordionGroup>
  <Accordion title="Snowflake">
    <Steps>
      <Step title="Output table name">
        <Tip> This input supports parameter syntax</Tip>
        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.
      </Step>

      <Step title="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.
      </Step>

      <Step title="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.
      </Step>
    </Steps>
  </Accordion>
</AccordionGroup>