⚡️ Other integrations

Enabling Sync

Configuring how often to import data from your warehouse

Schedule and Start Syncing

Finally, configure how often you wish to sync data from your data warehouse. From the drop-down on the Sync schedule tab and enable sync by toggling the Sync my warehouse data into Vitally toggle.

When finished, simply click the Start syncing my data into Vitally button to enable the synchronization and begin importing data.

Setting the Sync schedule

That's it! 🎉

Your data will begin importing immediately, and will be re-synced at the scheduled number of hours you selected.

FAQ

How do I sync multiple data points into Vitally across multiple queries? Let's say you wanted to sync data into Vitally from multiple tables. For example, let's say you wanted to count rows from one table and rows from another, and sync those counts into Vitally as 2 account traits. To do that, you can:

  1. Use subqueries - in your main query, leverage a subquery to query each table and pull that result back into your main query as a column.

  2. Create multiple connections - If the solution above gets a little unwieldy, you can create multiple connections to your warehouse database and have each select simply compute data from a single table.

Example of multiple PostgreSQL connections