Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Checking Large Databases with Snowflake Integration in Clay | Clay

Checking Large Databases with Snowflake Integration in Clay

·Nov 10, 2025 11:17 AM·

Clay S. I have a client who wants me to check a large (800,000 rows) database against another large database. I understand that there is a Snowflake integration at the enterprise level (which they have). Is it possible to do that with such a large database in Clay?

Loading attachments

9 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes, you can handle 800,000 rows with our Enterprise plan using two approaches:
1. Passthrough Tables - Bypass the standard 50,000-row limit by enabling this Enterprise feature that handles rows on a rolling basis.
2. Bulk Enrichment - Run enrichments on millions of records imported from Snowflake within a single workflow, without manual effort. [1]
The Snowflake integration allows you to import data directly from your Snowflake data warehouse and perform lookup operations to check if rows exist in your database. [2]
Clay Support
APP
·
·
Did that answer your question?
Jalen N.
·
·
Yes. Awesome. That is great
Clay Support
APP
·
·
Great to hear that! If you have any more questions or need further assistance, feel free to ask.
Jalen N.
·
·
How do I enable that Enterprise feature?
Clay Support
APP
·
·
Passthrough Tables is an Enterprise feature that bypasses the standard 50,000-row limit by handling rows on a rolling basis. You can define the number of rows retained (the default is 100), and it provides automatic deletion to ensure seamless operation without needing to duplicate workbooks or create additional tables.
Are you looking to enable Passthrough Tables specifically, or do you need information about setting up the Snowflake integration itself for your Enterprise account?
Clay Support
APP
·
·
If you still need help with enabling Passthrough Tables or setting up the Snowflake integration, I’m here to assist. Would you like to provide more details about what you’re trying to accomplish so I can support you further?
Jalen N.
·
·
Okay. Thank you
Clay Support
APP
·
·
You're welcome. If you have any more questions or need further assistance, just let me know.