Skip to main content
KnoCommerce Managed ETL

KnoCommerce's solution to push data into CDPs and data warehouses

Updated over 9 months ago

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

  1. BigQuery Project ID - the identifier for the BQ project in your Google Cloud Instance

  2. Correct Access to BQ Project using EITHER

    1. your organization's service account - in this case, we would need a JSON file with private key details (BigQuery Documentation under Step 3)

      OR

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

  1. EITHER Host name OR Host IP Address of database server

  2. User name configured in Snowflake

  3. Database name in Snowflake

  4. EITHER Auth/Password combo OR Auth/Key-Pair

Did this answer your question?