Available for Enterprise customers.
| Method | How It Works | Best For |
|---|---|---|
| External Tables (Recommended) | Kadoa → S3 → Snowflake | Most use cases |
| Data Sharing | Kadoa Snowflake → Your Snowflake | When both parties use Snowflake |
External Tables (Recommended)
This is our recommended approach. Kadoa pushes Parquet files to an S3 bucket, and you create Snowflake external tables that query S3 directly.Why External Tables?
- No data duplication - Query S3 directly without copying data
- Always fresh - New extractions appear instantly
- Cost efficient - Pay for storage once, in S3
- Flexible - Works with any S3-compatible storage
Setup Steps
1. Configure S3 Data Connector
First, Kadoa push data to a S3 bucket. See Cloud Storage for detailed setup instructions.The S3 bucket metadata can be customized as needed. Please contact support for assistance with configuring your connector.
Data Sharing
If both Kadoa and your organization use Snowflake, you can use Snowflake’s native data sharing feature for zero-copy data access.How It Works
- Kadoa creates a secure share containing your workflow data
- You create a database from the share in your Snowflake account
- Query the shared data as if it were local tables
Setup Steps
- Contact Kadoa - Provide your Snowflake account identifier
- We create the share - Kadoa sets up a secure share for your team
- You accept the share - Create a database from the share in your account
Considerations
- Read-only access - Shared data cannot be modified
- Zero-copy - No data duplication, no additional storage costs
- Real-time - Changes appear immediately
Which Method Should I Choose?
| Requirement | Recommendation |
|---|---|
| Need to transform data before loading | External Tables |
| Want simplest setup | Data Sharing |
| Using multiple cloud providers | External Tables |
| Both parties already on Snowflake | Data Sharing |
| Need to combine with other S3 data | External Tables |
Next Steps
- Set up Cloud Storage for External Tables
- Contact us to set up Data Sharing