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.
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 select an existing credential, select your saved credentials in the My Credentials section and click Next.
To add new credentials:
Click Connect with Snowflake to add your Snowflake credentials.
Enter your Snowflake connection details:
Account identifier
Username
Private key
(Optional) Passphrase
Click Next to store your credentials.
Select your table in the Choose Table step.
Select a warehouse, database, schema, and a table in the same order from the corresponding drop-down lists.
The options in the drop-down lists populate based on what you select in the hierarchy of options. For example, the options for the Database drop-down list populate based on your warehouse selection.Click Next to configure your data source settings.
Select the columns and fields you want to import in the Fields section.
(For data containing columns with a monetary unit) Select a currency for all your data or select a column that specifies a currency in one of its rows.
When you Select a field containing the currency, the columns with a string value are populated in the drop-down list.This section is greyed out if your data doesn’t have any columns with a monetary unit.
(For data containing columns with a date unit) Select how Funnel should fetch your Snowflake data and store.
You have the following options:Date by daily date: Select a column that has a date unit. Only columns with a date value are populated in the drop-down list.
Dateless: Select this option if you want Funnel to fetch data with no date mapping. If you import large tables, the costs may be high because Snowflake scans the entire table.
This section is greyed out if your data doesn’t have any columns with a date unit.
Define the values in the Download Configuration section.
Select values in the following fields:How often should Funnel download your data? Select one of the options from the drop-down list. You can choose to download data in hourly frequencies or every day.
(Available only if you selected Date by daily date in the previous step) How much historic data would you like? Select a date from when Funnel should start downloading the data.
(Available only if you selected Date by daily date in the previous step) How much historic data should be refreshed with each download? Enter the number of days for which Funnel should refresh the historical data. The days are usually counted backwards from the current day.
Assume today’s date is 28 May 2025 and you entered the following values for the following three fields:How often should Funnel download your data? Every day
How much historic data would you like? 1 Apr 2025
How much historic data should be refreshed with each download? 3
Funnel, then, refreshes the historical data only for today and the last two days, which is from 26 May 2025.
Important: The computing costs in Snowflake depend on the option you select.
Click Next.
Review the configuration summary, and click Connect Data Source.
Your Snowflake data will begin syncing to Funnel. Initial data 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.