All docs
/
Transform
/
Auto-delete in tables

Auto-delete in tables

Efficiently process and enrich large volumes of data.

Overview
Note: This is a feature available to users on the Enterprise Plan.

Auto-delete is a powerful feature designed to help you process and enrich large volumes of data efficiently. It allows you to bypass the standard row limit by automatically processing incoming data, enriching it, and then forwarding it to a designated destination before deleting the original entries from the table. This ensures your tables remain manageable while continuously handling new data.

Note that auto-delete does not apply to CSVs, including bulk uploads at high volumes.

Enable auto-delete

Follow these steps to set up auto-delete:

  1. Open a table.
    • Note: Auto-delete works with tables whose source is a webhook, send table data, signal, or Audiences source. Other source types stop importing at 50,000 records even with auto-delete enabled.
  2. Click the title of the table and select Enable auto-delete.
  3. In the Auto-delete modal, confirm your source type by checking This table uses a webhook, send table data, signal, or Audiences source., then click Configure auto-delete.
  4. Under Auto-delete mode, select one of the following options:
    • Disabled — Rows will not be automatically deleted.
    • Delete when all actions finish — Deletes rows once all action columns have finished running.
      • Optionally, select a Success column from the dropdown. When set, a row will only become eligible for deletion after that specific column has run successfully. If no column is selected, rows are deleted as soon as all actions finish.
    • Delete based on conditional rules — Deletes rows that match a set of custom filter conditions you define. Use this mode to trigger deletion based on more complex logic, such as time created or updated, values in a column, or column run status.
      • Click Add filter to build your conditions. At least one filter rule is required to save this mode.
  5. Optionally, enter a value in the Number of rows to keep field. This sets how many of the most recent rows are retained in the table when auto-delete runs. Leave the field empty to use the default of 100 rows.
  6. Click Save changes.
Warning: Deleted rows are not recoverable.

Explore other docs

Settings & admin

Set up SCIM provisioning in Clay

Keep your Clay workspace membership and roles in sync with your identity provider.

View article
Gen AI

Scheduled tasks

Set a task to run on its own — daily, on weekdays, weekly, or monthly — so recurring go-to-market work happens without you starting it.

View article
Gen AI

Knowledge Hub

Keep one reviewable record of your business in Clay — what you sell, who you sell to, and what signals matter — that Clay drafts and you edit.

View article
Enrich

Upriver integration

Map the sponsorships, products, and audiences behind any brand.

View article
Settings & admin

Beta program

Get early access to new Clay features through the Beta program, and see how to join, leave, and share feedback.

View article
Enrich

G2 integration

Find software products on G2, pull their ratings, features, reviews, and competitors, and build lists of companies researching the categories you compete in.

View article
Gen AI

Clay (global agent)

Chat with Clay, our global agent, to build and run go-to-market plays: it plans, analyzes, and carries out work across many of Clay's surfaces.

View article

Other popular resources

Experts

Find a Clay Expert

Explore our network of Clay experts and agencies.

View experts
Community

Join our slack community

Find help in our slack community, and support channels.

Go to slack
Cohorts

Join a cohort, learn Clay fast!

The faster way to master Clay. Sign in if you're enrolled in a cohort (current or past) or apply!

Learn more about cohorts
Talents

Hire GTME Talent

Find and connect with GTM talent who've demonstrated expertise in building advanced workflows

Explore GTME talents