Introduction
This integration enables users to update rows in Snowflake databases through Clay’s platform. Utilizing Snowflake’s UPDATE statement, this action allows for the updates/modifications of existing records based on specified query conditions. This ensures efficient and accurate updates to Snowflake tables without direct SQL manipulation, leveraging your Clay data.
Provider: https://snowflake.com
API Documentation: https://docs.snowflake.com/en/sql-reference/sql/update
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 |