.png&w=3840&q=75){kind=logo}
How to Generate Datasets Larger Than 50,000 Rows for Preview
Hi - Is there a way to get a table larger than 50,000 rows? I am having trouble generating a preview beyond 50,000 rows and have datasets in the hundreds of thousands of rows.
Yes, if you're an enterprise customer, you can use Passthrough tables to handle larger datasets. Passthrough tables allow you to bypass the standard 50,000 row limit by automatically processing incoming data, enriching it, and forwarding it to a designated destination before deleting the original entries from the table.For standard tables, the limit remains at 50,000 rows per table. If you need to exceed 50,000 records in a regular search, you will need to upgrade your plan. Sources: Find Company overview | Clay University Passthrough features guide | Clay University
if you want more than 50,000 records in a regular search, what plan exactly is necessary if I already have Enterprise?
Even with an Enterprise plan, the maximum limit for records per search is 50,000. If you need to exceed this limit, you'll need to upgrade your plan. The Enterprise plan includes features like unlimited users, custom credits, and various integrations, but maintains the same 50,000 search limit per query. Sources: Find Company overview | Clay University Free vs. Starter vs. Explorer vs. Pro vs. Enterprise Plans Clay Plan Feature Overviews
what plan has more than 50,000 records per search given the response continues to be "upgrade your plan"? I'm guessing that is a mistake/error
Bo (.··Hey, thanks for reaching out - The best way to have more than 50k searches would be with the auto-delete row function that automatically deletes the rows once they have run. Want me to connect you with our team if you don't have that feature?
I have that feature
- Bo (.··
The 50,000 record limit is actually a technical constraint to keep tables running smoothly, not a plan limitation. What specific data are you trying to collect? There might be better ways to structure your search or use upcoming API features to get what you need. Let me know what you're working on and I can suggest some alternatives.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.