Snowflake provides cloud-based data warehousing and analytics capabilities that help you store and analyze large volumes of data. The Snowflake connector in Funnel allows you to integrate your data warehouse metrics with other marketing data sources for comprehensive reporting and analysis.
Before you begin
Where can I find this connector? | Minimum requirements |
|
|
Guidelines, requirements, and limitations
Account requirements
You must have an active Snowflake account with appropriate database access permissions.
Your Snowflake account must have the necessary privileges to read data from the tables you want to connect.
You need sufficient permissions to create and manage database connections.
Database credentials
Before connecting in Funnel, ensure you have the following Snowflake connection details:
Account identifier: Your Snowflake account identifier, for example,
abc12345.us-east-1Username: Database username with appropriate read permissions
Private key: Secure private key for the database user
Database name: Target database containing your data
Schema name: Specific schema within the database
Warehouse name: Snowflake warehouse for query execution
Note: Contact your Snowflake administrator if you need assistance obtaining these credentials or configuring network access.
Network access
Funnel connects to Snowflake from static IP addresses. If your Snowflake account uses a network policy, allow Funnel's IP addresses so Funnel can ingest your data.
Use the IP addresses that match your Funnel workspace region:
Region | Funnel workspace | IP addresses |
US |
| |
EU |
|
Data limitations
Data availability depends on your Snowflake account permissions and table access.
Historical data access varies by account type and data retention policies.
Data refresh frequency is determined by your Snowflake warehouse settings and query performance.
Large datasets may require appropriate warehouse sizing for optimal performance.
Performance considerations
Query performance depends on your Snowflake warehouse size and configuration.
Large datasets may take longer to process depending on warehouse capacity.
Consider using appropriate warehouse sizing for data-intensive operations.
Data processing time varies based on query complexity and data volume.
Procedure
Follow these steps to connect your Snowflake data to Funnel:
Go to Connect > Data sources, and click + Connect Data Source.
Search for Snowflake in the search bar, and click Connect Now.
In the Select Credentials step, select an existing credential or add new credentials.
To use an existing credential, select it in My Credentials, and click Next.
To add a credential:
Click Connect with Snowflake.
Enter the Account identifier, Username, Private key, and optional Passphrase.
Click Next to store the credential.
In the Choose Table step, select a warehouse, database, schema, and table in that order. The available options update based on each preceding selection.
Click Next, and select the columns and fields you want to import in the Fields section.
For data containing monetary values, select one currency for all data or select a column containing the currency. When you Select a field containing the currency, the drop-down list shows columns with string values. This section is unavailable if your data has no columns with a monetary unit.
For data containing dates, select how Funnel should fetch and store your Snowflake data. This section is unavailable if your data has no columns containing dates:
Date by daily date: Select a column containing dates.
Dateless: Select this option to fetch data without date mapping. Snowflake scans the entire table, which may increase costs for large tables.
Define the following values in Download Configuration. For example, if today is 28 May 2025, the historic start date is 1 April 2025, and the refresh window is three days, Funnel refreshes data from 26–28 May 2025. Important: Your selections affect Snowflake compute costs.
How often should Funnel download your data? Select an hourly frequency or every day.
How much historic data would you like? Select the date from which Funnel should start downloading data. This is available only for Date by daily date.
How much historic data should be refreshed with each download? Enter the number of days to refresh, counting backward from today. This is available only for Date by daily date.
Click Next.
Review the configuration summary, and click Connect Data Source. Your Snowflake data begins syncing to Funnel. Initial processing may take several hours depending on your data volume and warehouse configuration.
Next steps
View your Snowflake data in the Data sources page.
Create dashboards to analyze your data warehouse metrics.
Combine Snowflake data with other marketing and business data sources.
Set up automated reports for data monitoring and analysis.
Monitor warehouse usage and optimize query performance as needed.