Overview
Snowflake is a cloud data platform used by organizations to store, manage, and analyze large volumes of structured and semi-structured data at scale.
The Alchemer integration with Snowflake supports automated data delivery from surveys directly into Snowflake. The Alchemer Snowflake integration allows Alchemer to push survey response data, session data, and question metadata into Snowflake tables — keeping your data warehouse synchronized with survey activity without manual exports or intervention.
Common uses for the Alchemer Snowflake integration
- Automatically push survey response data into Snowflake on submission
- Centralize survey and session data alongside other business data in Snowflake
- Eliminate manual CSV exports and data pipeline maintenance
- Keep Snowflake tables synchronized with real-time survey activity
- Make survey data available for reporting and analytics in Snowflake
What can the Alchemer Snowflake integration do?
You will need
- Snowflake API credentials (key pair authentication). More details in the authentication how-to guide.
- An Alchemer plan that includes integrations with the Integration Manager permission enabled.
- Contact us if you are unsure if your plan includes integrations.
- Create your objects using the headers in the CSV's below in Snowflake (these will be the tables and values that will be pushed)
Setup Alchemer Snowflake integration in surveys
Snowflake | Structured Response
You will need:
- Snowflake API credentials (key pair authentication). More details in the authentication how-to guide.
- A designated Snowflake database and schema where tables will be created
Configure the action
- Open your survey in Survey Builder.
- Select Add New: Action.
- In the Add Action modal, scroll to the Your Integrations section.
- Select Snowflake.
- Select Snowflake | Structured Response.
- Snowflake | Authentication: Select an existing authentication or create a new one.
- Snowflake | Select database: Select the Snowflake database you would like to use from the dropdown.
- Snowflake | Select schema: Select the Snowflake schema you would like to use from the dropdown.
- Snowflake | Select tables: Select your Snowflake tables you would like to use for the structured response.
- Snowflake | Validating tables: Checking if your Snowflake tables are properly built before proceeding. If you receive an error, ensure you've selected the correct table, and all required fields are created.
- Snowflake | Select data to push: Select the fields in this survey that contain the values you want to use to create the row in Snowflake.
- Snowflake | Pushing question data: Pushing question metadata to Snowflake for the selected questions.
- Snowflake | Get data back: Select metadata fields (e.g. message, status code) to return. These can be used to help debug your action setup.
- Save the action.
Status codes
- 200: Successfully pushed to Snowflake
- 400: The external integration returned an error
Testing and Troubleshooting
Testing and Validation
How to test
- Submit a survey response that triggers the integration action.
- Confirm the expected data appears in your Snowflake tables.
- Use returned metadata for verification and debugging.
How to verify results
- Check the affected tables in your Snowflake database.
- Ensure retrieved or pushed values match expectations.
Monitoring Integration Activity
Where to find logs
- Go to Results → Individual Responses.
- Select the response you want to inspect.
- Open the Action Log tab.
What logs display
- Success or failure status
- Timestamp
- Input and output values
- Returned status codes from Snowflake
Troubleshooting
Authentication issues
- Incorrect or expired key pair credentials
- Missing permissions in Snowflake
Table issues
- Insufficient privileges to create or write to tables
- Incorrect database or schema specified during authentication
Mapping errors
- Unsupported or invalid field types
- Incorrect formatting
API errors
- Validation issues
- Endpoint restrictions
FAQs
What permissions do I need?
Integration Manager in Alchemer and sufficient privileges in Snowflake to create and write to tables in the target database and schema.
When does the integration run?
In real time when a survey response is submitted.
Can I use multiple Snowflake actions in one survey?
Yes. Actions can work independently or together. However, the structured response is only intended to be used once.
Why isn't my data updating?
Check the Action Log for lookup issues, mapping problems, or API errors.
What if I need additional functionality?
Contact Alchemer Support for enhancement requests.
