All docs
/
Getting started
/
Table management settings

Table management settings

Manage table settings like rename, auto-dedupe, auto-updates, auto-delete, and table descriptions.

Overview

Access table management settings

You can access your table settings via your table settings dropdown.

  • For workbooks: Locate the table dropdown in the bottom workbook navigation bar.
  • For tables: Find the table dropdown in the left section of the top navigation bar.

Auto-dedupe

Auto-dedupe continuously monitors a specified column to detect and resolve duplicate values by retaining the oldest row and deleting the duplicates. Blank cells and cells with more than 200 characters are excluded from this process.

To enable or disable auto-dedupe:

  1. Open your table settings dropdown.
  2. Click the table dropdown menu and select Enable/Disable auto-dedupe
  3. Toggle the auto-dedupe setting on or off.
  4. Select the column to be used for identifying duplicate values.

Auto-update

Auto-update automatically runs all columns whenever rows are added or edited, keeping your table current. You can enable or disable this feature at both the table and column levels.

Note: Ensure your table is not running before enabling or disabling auto-update.

To enable or disable auto-update:

Table:

  1. Click the table name to access table settings.
  2. Select Enable auto-update / Disable auto-update.

Individual columns:

  1. Click the name of the column → Edit columns.
  2. Toggle auto-update on/off under Run settings. Click Save to apply your changes.
    • If auto-update is disabled for the table, it will override any column-level auto-update settings.

Duplicate table

Note: Duplicating a table will only copy the sources. You cannot duplicate all of the data within a table.

To duplicate your table:

  1. Click on the title of the table on the top left.
  2. Select Duplicate table.

View table graph

Graph view helps you visualize the enrichments and their relationships in your table. It enables you to explore data connections and edit directly within the graph.

To view your table graph:

  1. While in a table, open the Views menu in the top-left corner.
    • This will usually say Default view.
  2. Select Graph view.

Manage enrichments from table graph view

You can edit or add enrichments while using the graph view to refine your data.

  • Edit Existing Enrichments:
    • In the graph view, click on a node or connection to adjust relationships.
    • Modify enrichment settings directly to ensure the data meets your requirements.
  • Add New Enrichments:
    • Switch back to the table view by closing the graph.
    • Click the Add Enrichment button in the top-right corner to create and configure new enrichments.

Auto-delete

Rename your table

To rename your table:

  1. Open your table settings dropdown.
  2. Select Rename and enter your new table name.

Edit table description

To edit your table description:

  1. Open your table settings dropdown.
  2. Select Edit table description and enter your new table description.

Explore other docs

Web scraping

Sumble integration

Validate whether a company uses specific technologies.

View article
Export

Microsoft Teams integration

Send messages to Microsoft Teams channels directly from Clay.

View article
Enrich

EmailBison integration

Import leads into campaigns directly from Clay, ensuring accurate and efficient campaign execution.

View article

Keyboard shortcuts

Work faster in Clay with keyboard shortcuts.

View article
Export

Salesforce SOQL

The Salesforce SOQL source enables you to import records from Salesforce by writing custom queries.

View article
Transform

Share workbooks and tables as templates

Share your Clay workbooks and tables.

View article
Enrich

Zerobounce integration overview

Email validation and deliverability tools boost inbox placement and marketing ROI.

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 to an upcoming one!

Learn more about cohorts