Snowflake Integration
Snowflake is Zingle's primary warehouse integration. It powers data preview in the modeling workspace, query execution in the Playground, and serves as the compute engine for production pipelines.
What you need
| Requirement | Details |
|---|---|
| Account identifier | Your Snowflake account ID (without .snowflakecomputing.com) |
| Username & password | Credentials with appropriate permissions |
| Role | Snowflake role to assume (e.g., TRANSFORM_ROLE) |
| Warehouse | Default warehouse for query execution |
| Database | Target database |
| Schema | Target schema |
Connecting Snowflake
Navigate to Connections
Open Connections from the sidebar and scroll to the Snowflake Connection section.
Enter credentials
Click Connect Snowflake and fill in:
- Account identifier
- Username
- Password
- Role
- Warehouse
- Database
- Schema
Validate the connection
Zingle runs a validation query (
SELECT CURRENT_VERSION()) with a 30-second timeout. If the query succeeds, the connection is saved.Credentials are stored as secret references, not as plaintext in configuration.
Connection status
Once connected, the Snowflake card shows:
| Field | Description |
|---|---|
| Status | Active or Unknown |
| Account | Your Snowflake account identifier |
| User | Connected username |
| Role | Active role |
| Warehouse | Default warehouse |
| Database | Target database |
| Schema | Target schema |
You can Disconnect at any time from this card.
What Snowflake enables
| Feature | How Snowflake is used |
|---|---|
| Data preview | Query source tables from the AI modeling workspace |
| Playground queries | Execute ad-hoc SQL from the Playground |
| Compute engine | Run production pipelines on Snowflake warehouses |
| Schema introspection | Discover available tables and columns |
Troubleshooting
SNOWFLAKE_AUTH_FAILED
Snowflake rejected your credentials. Double-check:
- Username and password are correct
- The user has access to the specified role, warehouse, database, and schema
SNOWFLAKE_INVALID_ACCOUNT
The account identifier is wrong. Common mistakes:
- Including
.snowflakecomputing.com(don't) - Wrong region suffix
- Typos in the account name
Copy the identifier directly from Snowflake → Admin → Account Details.
SNOWFLAKE_RESOURCE_NOT_FOUND
The specified warehouse, database, or schema doesn't exist, or the user's role doesn't have access. Verify in the Snowflake UI that all resources exist and are accessible under the configured role.
SNOWFLAKE_CONNECTION_TIMEOUT
Zingle couldn't connect within 30 seconds. Check:
- Network connectivity between Zingle and Snowflake
- VPN, firewall, or security group rules
- Whether the Snowflake account is active and not suspended