Introduction
This integration enables the insertion of a single row of data into a specified Snowflake table using Clay’s automation capabilities. Leveraging Snowflake’s INSERT statement, users can add new records to their database via Clay. The action supports various data types and adheres to Snowflake’s syntax requirements, ensuring accurate and consistent data insertion.
Provider: https://snowflake.com
API Documentation: https://docs.snowflake.com/en/sql-reference/sql/insert
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 insert 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 |