Introduction
This integration enables data synchronization between Clay and Snowflake, allowing users to upsert rows into a Snowflake database. Utilizing a single field as a unique identifier, the action updates existing rows or creates new ones as needed. This functionality leverages Snowflake's SQL API, providing a method for maintaining up-to-date and accurate data across both platforms.
Provider: https://snowflake.com
API Documentation: https://docs.snowflake.com/en/developer-guide/sql-api/index
Input
Name | Is Optional | Description | Type |
Snowflake Account ID | [Click here to learn how to find this ID](https://docs.snowflake.com/en/user-guide/admin-account-identifier#finding-the-organization-and-account-name-for-an-account). Once pasted into this field, replace the period with a dash. | text | |
Database Name | Name of the database to query | text | |
Schema | The schema that contains the tables you'll query. Defaults to public. | text | |
Table Name | The name of the table you want to upsert data into. | text | |
Snowflake Warehouse | The warehouse to run the requests to snowflake with. | text | |
Role | true | Snowflake Role, defaults to `AccountAdmin` | text |
true | dynamicFields |