How to connect to Redshift
Vero can connect to your Redshift database, run queries against it and use the results of those queries to send email messages to your customers. In Vero, database connections are referred to as Data Sources.
Adding your database
To add an external database, click Data Sources and Add Data Source. In the menu that appears, choose the database you want to add:
To add a database you will need the following credentials:
- Host. The web or IP address of the database.
- Port. The port that is accepting connections (e.g. typically 5432 for PostgreSQL).
- Username.
- Password.
- Database name. The name of the database to connect to.
Testing your connection
Once you’ve entered your database credentials, select Connect. Vero will automatically test the connection:
Securing your connection
Create a read-only user
Vero will only execute SELECT
queries against your database: it is read only by design.
That said, we would recommend creating a user login that only has read access to your database.
Vero will show users all available tables when using the SQL editor in our UI. Limiting the tables and columns that Vero has access to is good practice.
IP whitelisting
Vero will connect directly to your database over the public internet. This approach requires your network and database to be configured to allow Vero’s servers to connect to it.
Find the list of active IP addresses Vero uses to connect to your database here. Whitelist these addresses to secure access to your data.
Currently supported Redshift versions
Vero Connect officially supports Amazon AWS Redshift (1.0+).
At the moment we support Redshift-style databases and it’s possible configurations outside of the above may work. That said, we currently only provide support for the database listed above.
We will be adding support for more database and data stores in the future, please let us know what you would like to see us support on our Vero Connect feedback board.
FAQs
Query limits
Vero will show your query results in blocks of 100 in the UI. In order to load an audience you will need to load your entire query (without a LIMIT
clause).
There is no technical limit to the number of rows you can query using Vero’s UI but we have currently tested up to one million rows consistently.
Query timeout
Vero will currently timeout queries after 12 hours.