Connect Snowflake with Statisfy
The Snowflake integration allows you to import data from your Snowflake data warehouse into Statisfy. Sync product usage metrics, customer attributes, and custom fields from your analytics infrastructure. Prerequisites:- Admin access to Statisfy
- Snowflake account with appropriate permissions
- Service account credentials (password or private key)
What You Can Import
| Data Type | Description | Use Case |
|---|---|---|
| Product Usage | Usage metrics and adoption data | Track MAU, enrolled users, activation rates |
| Custom Fields | Account-level attributes | Sync industry, status, dates from warehouse |
Authentication Methods
Snowflake supports two authentication options:Password Authentication
Password Authentication
Connect using username and password:Required credentials:
- Account identifier
- Username
- Password
- Database name
- Schema name
- Warehouse name
Private Key Authentication (Recommended)
Private Key Authentication (Recommended)
Connect using a private key for enhanced security:Required credentials:
- Account identifier
- Username
- Private key file (PEM format, PKCS8 encoding)
- Passphrase (if key is encrypted)
- Database name
- Schema name
- Warehouse name
Steps to Connect
- Log in to Statisfy.
- Navigate to: Integrations → Admin Apps → Snowflake → Connect
-
Enter your Snowflake credentials:
- Account: Your Snowflake account identifier
- Username: Service account username
- Password or Private Key: Authentication credential
- Database: Target database name
- Schema: Target schema name
- Warehouse: Compute warehouse for queries
- Click Connect to validate and save credentials.
- Contact support@statisfy.com to configure your data mappings.
Product Usage Import
Import usage metrics to track customer product adoption: Supported Metrics:- Monthly Active Users (MAU)
- Enrolled users and activation rates
- Department and user counts
- Custom calculated metrics (yields, percentages)
- Data is aggregated monthly
- Metrics reflect the previous calendar month
- Snowflake query aggregates usage data by account
- Results are matched to Statisfy accounts via CRM ID
- Metrics are mapped to product dimensions
- Values are stored for reporting and analysis
Custom Field Sync
Sync account attributes from your data warehouse: What you can sync:- Industry classifications
- Onboarding and deactivation dates
- Account status and type
- Partner information
- Custom attributes
| Snowflake Column | Statisfy Field |
|---|---|
| INDUSTRY | Industry |
| ONBOARDEDDATE | Onboarded Date |
| EMPLOYER_STATUS | Employer Status |
| CHANNEL_PARTNER | Channel Partner |
Data Matching
Rows in Snowflake are matched to Statisfy accounts using:| Match Method | Description |
|---|---|
| CRM Account ID | Salesforce or HubSpot account identifier |
Sync Behavior
Scheduled Jobs:- Data is pulled on a configured schedule
- Monthly aggregation for product usage metrics
- Only active accounts are processed
- Inactive accounts (no recent activity) are excluded
- Invalid rows are logged and skipped
- Missing field mappings generate warnings
- Sync continues even if some records fail
Configuration
Snowflake configuration is handled by the Statisfy team. Contact support to set up or modify your integration.
- Connection credentials (stored securely)
- Query definitions for your data model
- Field mappings to Statisfy attributes
- Sync schedule and frequency
Troubleshooting
Authentication failed
Authentication failed
Check credentials:
- Verify account identifier is correct
- Confirm username and password/key are valid
- Ensure the service account has appropriate permissions
- Verify the key is in PEM format with PKCS8 encoding
- Check that the passphrase is correct (if encrypted)
Data not syncing
Data not syncing
Check data requirements:
- Verify CRM Account IDs are present in your Snowflake data
- Ensure accounts exist in Statisfy with matching identifiers
- Confirm the service account can access the database, schema, and warehouse
Missing metrics
Missing metrics
Check product dimensions:
- Verify product dimensions are configured in Statisfy
- Contact support to add missing dimension mappings
Security
- Credentials are stored encrypted in Google Cloud Secret Manager
- Private key authentication recommended for production
- All data transfers use secure connections
- Access is scoped to specific databases and schemas
Need Help?
Snowflake integration requires custom configuration. Contact support@statisfy.com for:- Initial setup and credential configuration
- Query customization for your data model
- Field mapping configuration
- Troubleshooting sync issues