I have enterprise clay plan and I cant use more then 50k rows in one table but on the pricing page it says unlimited rows
You're right that Enterprise includes unlimited rows, but you need to enable "Passthrough Tables" to access this feature.
Regular tables are still capped at 50,000 rows even on Enterprise. Passthrough Tables work differently - they handle rows on a rolling basis and automatically delete older rows to maintain continuous data flow.
To enable Passthrough Tables for unlimited rows, you'll need to activate this specific Enterprise feature in your table settings. [1]
Is that what you were looking for?
is it the bulk enrichment?
No, Bulk Enrichment is different from Passthrough Tables. Both handle unlimited rows on Enterprise, but they work differently:
Passthrough Tables are regular Clay tables that automatically delete older rows to maintain continuous data flow while staying within your workspace.
For unlimited rows in a standard table, you'd use Passthrough Tables, not Bulk Enrichment.
Did that answer your question?
can i see all the data in one tale if using passthrough table or will it show data in small bits like 10k or 20k at a time
With Passthrough Tables, you can define how many rows are retained (default is 100), but you can view all the retained data at once in your table.
You can also use the row formatting controls to set custom row limits - click the "Rows" button to set starting row and row limit, or use "Show All Rows" to display everything at once. [1]
So it's not limited to small chunks like 10k or 20k - you control the display based on your retention settings and view preferences.
Was this helpful?
If you need any more help understanding how Passthrough Tables work or managing your data display, I’m here to assist. Would you like to share more about what you’re trying to achieve with your table setup?
i have half a million rows need those in on table
For 500k rows in one table, you'll need Bulk Enrichment - it's designed specifically for millions of records. [1]
Passthrough Tables won't work for your use case since they automatically delete older rows to maintain flow, so you'd never see all 500k at once.
With Bulk Enrichment, you import from Salesforce, enrich the data, then send results to your destination systems without storing everything in Clay tables. Access it via New → Bulk Enrichment from your homepage.
Is that what you were looking for?
If you still need help with handling your large dataset or understanding the best way to manage your rows, I’m here to assist. Would you like to provide more details about your specific goals or challenges with your table setup?
