Available on Pro Plans and Enterprise Plans for an additional monthly charge
Supported Data Destinations
BigQuery
Snowflake
Redshift
Databricks
S3 Data Lake
These are the most commonly used data destinations, but more are available. Please reach out to hello@knocommerce.com to see if your data destination is supported.
How It Works
KnoCommerce uses our FiveTran instance and REST API to set up an ETL with a destination of your choice. The data that we will pass to you includes a table of survey data and a table of survey response data.
Once we have the necessary information (see requirements below) to connect to your chosen data destination, we will perform a historical sync of all data and continue data syncs every 6 hours.
What Data You Get
Survey Data
Response Data
Destination Requirements
Each destination has slightly different requirements for a properly configured connection, but the basic formula requires the following:
a destination identifier so we can send the data to your account
proper permissions to be able to access the account and transmit the data securely
BigQuery
BigQuery Project ID - the identifier for the BQ project in your Google Cloud Instance
Correct Access to BQ Project using EITHER
your organization's service account - in this case, we would need a JSON file with private key details (BigQuery Documentation under Step 3)
OR
we will provide a service account to you that would need to be assigned the BigQuery User role
Snowflake
The overall documentation for Snowflake is a bit more complex, but more detailed instructions can be found in the Snowflake Documentation.
EITHER Host name OR Host IP Address of database server
User name configured in Snowflake
Database name in Snowflake
EITHER Auth/Password combo OR Auth/Key-Pair