Step 1 - Query
After connecting to your warehouse, you can start syncing NPS Responses by configuring the query that Vitally will run against your warehouse on each sync.
Once you've entered your query, be sure to click the Preview Query button, which will execute your query against your warehouse and return the first row fetched from your targeted table.
You'll use the previewed query and returned row further along in the configuration below.
Incremental Sync
Incremental sync is a process of syncing warehouse data that has only been added or modified since the last sync cycle, instead of processing the entire dataset each time. This approach is more efficient as it minimizes the amount of data queried and processed during each sync, making the update process quicker and resource-efficient.
Incremental sync is required for syncing NPS Responses
In order to incrementally query your data each sync, you'll need to add a clause to your query with the variable $LAST_SYNC_TIMESTAMP. We'll fill in that variable with the timestamp of the last sync each time we query the warehouse.
Incremental syncs should compare the $LAST_SYNC_TIMESTAMP with a timestamp that reflects when the data was synced to the data warehouse. This is particularly important when data is synced to the data warehouse in batches.
SELECT id, "userId", score, feedback, "respondedAt"
FROM "Nps_Session"
WHERE "respondedAt" > $LAST_SYNC_TIMESTAMP;
Step 2 - Configure
Once you input and preview your query, you'll be presented with a few additional configuration options to map the columns from your SELECT statement to the required Vitally fields.
Step 3 - Continue Configuration
If you have other features to sync continue configuring those.