Product

Use Cases

Solutions

Resources

Company

Pricing

Data infrastructure

Agents

Orchestration

Execution

Clay MCP

Give reps the best prospecting data in their AI tools

BY CUSTOMERS

Pump

Pump

Link long form description will go in this slot here.

Northbeam

Northbeam

Link long form description will go in this slot here.

Saviynt

Saviynt

Link long form description will go in this slot here.

Recharge

Recharge

Link long form description will go in this slot here.

ElevenLabs

ElevenLabs

Link long form description will go in this slot here.

CRM enrichment

Keep your CRM clean with the highest quality data

Data foundations

Pipeline generation

Rep productivity

Department

Intercom

Grew their outbound-sourced pipeline by +140%

Learn to build on Clay

Connect with GTM engineers

Work with GTM engineers

Partner with Clay

Clay Community

In Nigeria, she built a life where money wouldn’t decide

OUR COMPANY

GET IN TOUCH

SOCIALS

Article – NY Times

Clay allows employees to sell shares at a $5b valuation.

Get a demo
Sign up
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
No items found.
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