Skip to main content
Update Row with Snowflake

Update row in database using a query from that table to find matching records

Updated over 3 months ago

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.

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

Did this answer your question?