Snowflake - Merge action
This action merges data between two tables in Snowflake, allowing you to insert or update rows in a target table by matching values with a source table.
Ensure that both tables have an identical schema. This action only supports the following cases:
- Values that match (for updates).
- Values that do not match (for inserts).
Input
| Input field | Description |
|---|---|
| Source table | Choose the source table or enter a custom table name. This table provides the data for the merge. |
| Target table | Choose the target table or enter a custom table name. This table receives the merged data. |
| Join expression | Define the merge condition. You can choose from the source and target table columns or enter it manually. |
Output
| Output field | Description |
|---|---|
| Rows affected | The total number of rows affected by the merge operation. |
| Rows updated | The number of rows updated in the target table. |
| Rows inserted | The number of rows inserted into the target table. |
Last updated: