Product Guide
  • Introduction
  • Product Training
    • Account & Project Management
    • Product Feedback Management
    • Product Guide For Session Replay & Heatmap
  • installation
    • Web
      • JavaScript SDK
      • Google Tag Manager
    • Mobile App SDK
      • Android Survey SDK
      • IOS Survey SDK
      • React Native SDK
    • Converse AI
      • Create a new Converse AI
      • Configure Conversation
  • Compose Survey
    • Create With AI
    • Survey From Scratch
    • Survey Templates
    • Enterprise Surveys
    • In-Product Surveys
    • Prototype Tests
    • Replays
    • Website Feedback Button
    • In-Product Video Widget
  • Survey Designer
    • Survey Theme
    • Survey Question Types
      • Welcome Page
      • Net Promoter Score (NPS)
      • Customer Satisfaction Score (CSAT)
      • Customer Effort Score (CES)
      • Video
    • Advance Survey Design
    • Survey Design Guidelines
  • Launch Survey
    • Web Surveys
    • Social Media Survey
    • Email Survey
    • Bulk Email Surveys
    • SMS Survey
      • SMS Survey By Link
    • Website Feedback
    • Events
  • Survey Branching
    • Jumping Questions
    • Disqualify Response
    • Terminate
  • Integration
    • Shopify
    • Slack
    • Google Sheet
    • Zendesk
    • Freshdesk
    • Zapier
    • Google Analytics
    • Square Online Integration
  • Workflows
    • Salesforce Workflow
      • Create an email campaign for Salesforce Case/Opportunity.
      • Map survey response data into Salesforce
        • Create event-based Salesforce workflow
      • Import contact data from Salesforce to Qwary
    • Zendesk Workflow
      • Send post-resolution email surveys campaign
      • Map survey response data into Zendesk
        • Event-based Zendesk workflow
    • Snowflake Workflow
  • Insights
    • Standard Reporting
    • NPS Reporting
    • CSAT/CES Rating
    • Key Driver Analysis
    • Text AI
      • Topics
  • Team Collaboration
    • Invite Team Member
    • Share Survey
    • Share Dashboard
  • Closed Feedback Loop
    • Workflow
    • Native Case Management System
    • Rule Based Email Notifications
  • Use Cases
    • Product Onboarding Surveys
    • Review Generation Campaigns
    • Square Online Customer Feedback
    • Ultimate Guide To Net Promoter Score (NPS)
    • Ultimate Guide For Customer Satisfaction Score (CSAT)
    • Ultimate Guide For Customer Effort Score (CES)
    • Product Survey Questions Guide
    • Segment customers for Email/SMS Surveys
  • Videos
    • Create a Survey
    • Create a Video Survey
    • Question Types
    • Design a Survey
    • Branching
    • Multilingual Surveys
    • Settings
    • Responses Settings
    • Distribute Survey
    • Square Online Integration
    • Analysis
    • Company Settings
    • Page
  • FAQ
    • Delete Test Responses
    • Turn off Qwary Branding
    • How to Configure Custom SMTP for Your Survey?
    • How to Request CNAME?
    • How to use Survey Variables?
    • Adding Hyperlink to Survey Text
    • GDPR Compliance
    • Survey Phishing
    • Enable GeoIP Collection for Your Survey
    • Add Custom Contact Field
    • Unsubscribe Contacts from List
    • Customize Image Size
    • Close Survey on Specific Date
    • Install Qwary Intercept with Single Page Applications
    • Move Survey Question
    • Download Response
    • Enable Partial Submission
  • Account & Billing Management
    • Reset Password
    • Invite Team Member
  • Converse AI
Powered by GitBook
On this page

Was this helpful?

  1. Workflows

Snowflake Workflow

PreviousEvent-based Zendesk workflowNextStandard Reporting

Last updated 2 years ago

Was this helpful?

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.

  1. Enter Snowflake Connection Details

Field
Value

Username

Your Snowflake account's username

Password

Your Snowflake account's password

Account

Warehouse

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.

  1. 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.

Your Snowflake account's account identifier. Refer ""

Your warehouse name. You can find it under your Snowflake account and go to Admin --> warehouse --> warehouse name

https://docs.snowflake.com/en/user-guide/admin-account-identifier