Clay Icon

Automating Row Deletion in Clay When Exceeding 50k Limit

ยท
ยท

Hello, wondering if there a is method to automatically remove the oldest rows from a table once it has reached the 50k row limit. Currently just removing the oldest manually but figured there should be some mechanism in Clay to overwrite/delete the oldest. Thanks!

  • Avatar of Mark L.
    Mark L.
    ยท
    ยท

    Hello Dragan. We do have a feature that can auto-delete rows, designed for high-volume webhooks. However, this is available only on the Enterprise plan (https://www.clay.com/pricing). That said, when the limit is hit, Clay should return a 403 response, "Record limit reached". You would need to use that as signal to create/swap to a new webhook endpoint. I recognize this isn't ideal today, but I've made sure we have this use case captured for future product improvements around notifications/alerting, more generally.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Dragan K.
    Dragan K.
    ยท
    ยท

    The volume is not due to a webhook, i write to the table from a zap, so I was looking for something similar to a column that has a delete function if a formula evals to true from within clay, but seems like I'll just have to purge the table on a schedule manually.

  • Avatar of Mark L.
    Mark L.
    ยท
    ยท

    Ah, I understand. There are no conditional-delete abilities within Clay. I like the idea, though, that could be powerful. Please let me know of other questions!

  • Avatar of Dragan K.
    Dragan K.
    ยท
    ยท

    Just to maybe plant the seed, allow for a table setting that allows overwrites for certain tables, but off by default. Not really a question though

  • Avatar of Mark L.
    Mark L.
    ยท
    ยท

    Welcome feedback, though! Thanks for taking the time to share and elaborate on the use case.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Dragan K.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: