Snowflake Workflow

By integrating Qwary with Snowflake, businesses can effortlessly import valuable data encompassing product feedback, customer queries, user information, and more. After successfully loading the Qwary data into Snowflake, companies can merge it with their existing data and conduct comprehensive analysis for enhanced utilization.

Qwary's Snowflake integration helps with

1. Insert/Update response data from Qwary into a Snowflake table

2. Map NPS/CSAT/CES score into Snowflake

Steps to Connect Qwary to Snowflake

1. Go to Menu --> Workflow and use the existing event-based workflow or create a new event-based workflow.

   • To create a new workflow, click on 'Add Trigger' and choose the survey whose response you wish to map to a Snowflake table.

2. Click 'Add Task' and click 'Snowflake --> Execute a query in Snowflake to update/insert response data" connect button.

3. Enter Snowflake Connection Details

Field	Value
Username	Your Snowflake account's username
Password	Your Snowflake account's password
Account	Your Snowflake account's account identifier. Refer "https://docs.snowflake.com/en/user-guide/admin-account-identifier"
Warehouse	Your warehouse name. You can find it under your Snowflake account and go to Admin --> warehouse --> warehouse name
Database	Snowflake database name, which contains table and schema where you want to map response data.
Schema	Snowflake database name, which contains a schema where you want to map response data.

4. Once your account is connected, Qwary works with SQL. Snowflake supports standard SQL lanauge. Write a query that you would write to insert/update the data into the table. Below example inserts a new record for each new response into customer_satisfaction table which is inside acmeinc_db (database) & prod (schema).

DML for customer_satisfaction table

create table customer_satisfaction ( nps_score NUMBER, comment TEXT, customer_email TEXT )

Sql will look like below screenshot. Use 'PIPE DATA' to insert data into the sql. You can select from survey question, survey variable and contact details when piping the data into sql.

Once completed, click on 'SAVE' button and activate your workflow.