Introduction
This integration enables users to check for the existence of a specific row in their Snowflake database using Clay's Lookup Row action. Leveraging Snowflake's SQL API, the integration allows for efficient querying of large datasets stored in Snowflake's cloud-based data warehouse. Users can seamlessly verify data presence without directly accessing the Snowflake interface, streamlining data validation processes within their Clay workflows.
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. | text | |
Snowflake Warehouse | true | The warehouse to run the requests to snowflake with. | text |
Role | true | Snowflake Role, defaults to `AccountAdmin` | text |
SQL Query | longtext |