Category: Database Connectors
Introduction
This document is created to help setup a mindzieDataDesigner connector to Snowflake database. The mindzieDataDesigner is the ETL tool used by mindzieStudio to convert database tables to process mining event logs. The purpose of this document is to help creating the connection string and opening ports on the firewall if required.
Overview
The Snowflake connector provides high-performance connectivity to Snowflake data warehouses. Optimized for analytical workloads and process mining scenarios.
System Requirements
- Cloud Platform: Snowflake (AWS, Azure, Google Cloud)
- Authentication: Username/Password, SSO, Key Pair, OAuth
- Platform Support: Cross-platform cloud access
- Dependencies: Snowflake .NET connector
Connection String Format
Basic Format
Account=myaccount.region;User=username;Password=password;Database=database_name;Schema=schema_name;Warehouse=warehouse_name;
Connection Parameters
| Parameter | Description | Required | Example |
|---|---|---|---|
Account |
Snowflake account identifier | Yes | mycompany.us-east-1 |
User |
Snowflake username | Yes | MINDZIE_USER |
Password |
Snowflake password | Yes* | SecurePassword123 |
Database |
Default database | No | PROCESS_MINING |
Schema |
Default schema | No | PUBLIC |
Warehouse |
Compute warehouse | No | ANALYTICS_WH |
Role |
Snowflake role | No | ANALYST |
Connection Timeout |
Connection timeout | No | 60 |
Connection Examples
Standard Connection
Account=mycompany.us-east-1;User=MINDZIE_USER;Password=SecurePassword123;Database=PROCESS_MINING;Schema=PUBLIC;Warehouse=ANALYTICS_WH;
Connection with Role
Account=mycompany.eu-west-1;User=ANALYST_USER;Password=password;Database=DATA_WAREHOUSE;Schema=ANALYTICS;Warehouse=LARGE_WH;Role=ANALYST_ROLE;
Multi-Cloud Connection
Account=mycompany.aws-us-west-2;User=SERVICE_USER;Password=password;Database=ENTERPRISE_DB;Warehouse=AUTO_WH;
Troubleshooting
Common Issues
"Authentication failed" Error
- Verify account identifier format
- Check username and password
- Ensure user account is not suspended
- Verify MFA settings if enabled
"Warehouse not found" Error
- Check warehouse name spelling and case
- Verify warehouse exists and is accessible
- Ensure user has USAGE privileges on warehouse
"Database/Schema not found" Error
- Verify database and schema names
- Check access privileges
- Use fully qualified object names
Related Information
- Official Documentation: Snowflake Documentation
- Snowflake Connector: .NET Driver Guide
- Best Practices: Snowflake Performance Tuning
💡 Tip: Use Snowflake's automatic clustering and query acceleration features to optimize performance for large-scale process mining workloads.