Skip to main content
Data Sources let you connect Vero directly to your database or data warehouse. Once connected, you can write SQL queries to select customers and use the results as audiences for your campaigns.

​
Why use Data Sources?

  • Query your existing data — Build audiences from customer data already in your database without importing CSVs or syncing data manually.
  • Stay up to date — For recurring campaigns, Vero re-runs your query on each send to ensure your audience reflects the latest data.
  • Full SQL flexibility — Write custom queries to target exactly the customers you need.

​
Supported databases

Vero supports the following databases and data warehouses:

Snowflake

Connect using RSA key authentication

Google BigQuery

Connect using a service account

PostgreSQL

Connect with username and password

MySQL

Connect with username and password

Amazon Redshift

Connect with username and password

Microsoft SQL Server

Connect using SQL Server Authentication

​
Security

Vero only executes read-only SELECT queries against your database. We recommend:
  • Creating a dedicated read-only user for Vero
  • Limiting access to only the tables and columns you need for campaigns
  • Whitelisting Vero’s IP addresses in your firewall
Each database guide includes specific security recommendations.

​
Query limits

  • Results display in pages of 100 rows in the audience UI
  • No strict row limit — tested reliably up to 1 million rows
  • Queries timeout after 12 hours