All integrations
/
ClickHouse
/
Upsert row with ClickHouse

Upsert row with ClickHouse

Upsert a row into a ClickHouse table. Inserts via JSONEachRow; deduplication is handled by the table engine, so the target should be a ReplacingMergeTree-family table (otherwise duplicate rows are not collapsed).

overview
Action
Bring Your Own Account Required
type
Clay-built Integration
pricing plan
All Plans
Data strength
No items found.
data input
Database
Table
Contact ID
Email Address
Contact - First Name
Contact - Last Name
Company
Title
Score
Data output
No items found.

Other actions with ClickHouse

Webhook
Native
Native
HTTP API

Insert row with ClickHouse

Insert a row into a ClickHouse database.

API Optional
API Required
Learn more about this action
Webhook
Native
Native
HTTP API

Lookup row with ClickHouse

Check if a row exists in your ClickHouse database.

API Optional
API Required
Learn more about this action
Webhook
Native
Native
HTTP API

Update row with ClickHouse

Update rows in a ClickHouse table matching a WHERE clause. Runs as a synchronous mutation (ALTER TABLE ... UPDATE), which can be slow on large tables.

API Optional
API Required
Learn more about this action

Support docs & guides

Clay branded illustration of a wall made out of 3D, colourful, clay bricks and a whimsical person opening a door in the wall to access a new world of opportunities.

Clay University

Master Clay in a few core lessons. Uplevel your data enrichment, craft better outbound messages, and book more meetings.

Learn with Clay
Learn with Clay

Go to market blog

Our best content on growing your GTM motion, from outbound sales automation to AI lead generation.

Explore our blog
Explore our blog
Clay branded illustration made out of 3D clay objects showing whimsical operators connecting cables to 3D Clay table

Integrations

Browse through all the integrations you can connect to Clay in seconds and discover what you can do!

Explore integrations
Explore integrations
Clay branded illustration of a Clay table with colourful, 3D connectors made out of Clay around it

Templates

Power your outbound campaigns with our best templates.

Visit clay templates
Visit clay templates
Clay branded illustration of a messy tangle of 3D, colourful strings made out of clay being untangled into one, colourful, twisted string

Clay Experts

Hire a Clay Enterprise expert or find a Clay partner to help with your next project

Explore Clay experts
Explore Clay experts

Clay's Chrome extension

Clay’s Chrome Extension makes it wicked easy to find leads almost anywhere on the internet

Explore Chrome Extension
Explore Chrome Extension

Get help from our experts

Need help?

Check our docs for guides and info on how Clay works

Visit Clay docs

Clay Experts

Get dedicated support from leading GTM & RevOps agencies.

Browse experts