How to set up Snowflake
Connecting your own Snowflake
To connect your existing Snowflake instance, you’ll need:- An active Snowflake account
- A dedicated database, warehouse, and user for Cargo
- Proper role permissions configured
Connection details
To set up the connection, provide the following details when creating the connector:| Field | Description |
|---|---|
| Account | Your Snowflake account identifier |
| Database | The database created for Cargo (e.g., cargo_db) |
| Warehouse | The warehouse for Cargo operations (e.g., cargo_wh) |
| Role | The role with appropriate permissions (e.g., cargo_role) |
| User | The Cargo service user (e.g., cargo_user) |
| Password | The user’s password |
Snowflake actions
Once connected, you can use Snowflake in your workflows through.Run SQL query
Execute custom SQL queries against your Snowflake warehouse. Use cases- Data extraction – Pull specific data from your warehouse for enrichment or processing
- Advanced analytics – Run complex queries to power decision-making in workflows
- Data validation – Check data conditions before triggering actions
Write to table
Insert or update data in your Snowflake tables. Use cases- Data sync – Keep your warehouse updated with enriched or processed data
- Audit logging – Record workflow executions and outcomes
- Data aggregation – Store computed results for reporting
Snowflake data models
Cargo allows you to create data models on top of your Snowflake data that can be used to trigger Plays and power workflows.Creating Snowflake data models
| Field | Description |
|---|---|
| Name | Choose a descriptive name for your data model |
| Slug | Set a unique identifier that cannot be changed once created |
| Source | Select the Snowflake table or view to model |
Network configuration
If you’re using Snowflake’s Allowed IPs network policy, add these Cargo IP addresses to your whitelist:3.251.34.13454.220.135.9979.125.105.52
Security
- All Snowflake connections are encrypted using SSL/TLS
- Credentials are securely stored and encrypted at rest
- Cargo supports RSA key-pair authentication for enhanced security
- Cargo never overwrites existing tables—it always creates its own