How to connect to Snowflake
In Vero Connect you can connect to databases and data warehouses, write and run SQL queries directly in your database and use the results of your queries to generate audiences to message. Database connections are referred to as Data Sources in Vero.
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 feedback.getvero.com/newsletters.
Adding a Snowflake connection
To add a Snowflake database as a Data Source click Data Sources and Add Data Source. In the menu that appears, choose Snowflake:
To add a Snowflake connection the following fields are required:
- Host. The web or IP address of the database.
- Port. The port that is accepting connections (e.g. typically 443).
- Database name. The name of the Snowflake database you want to use.
- Warehouse. The name of the Snowflake compute warehouse.
The following fields are optional:
We recommend including a role. If a
role is not provided Snowflake will default to the
public role that all users have access to.
schema helps narrow down the list of available tables presented in Vero's query interface:
Vero will only execute
SELECT queries against your database. It is read only by design. We recommend creating a unique
role for Vero Connect and granting access on an as-needed basis to the databases, schemas, tables and warehouses you need access to. Some points to remember:
- When creating a custom
role, make sure you grant
usagerights to the warehouse you'll be using with Vero Connect, not just the databases.
- As noted above, when setting up your Snowflake connection in Vero Connect providing a
roleis recommended. Without a
roleSnowflake defaults to the
publicrole. As a result, any databases, tables or other resources that are accessible via the
publicrole can be displayed and used in Vero.
Testing your connection
Once you’ve entered your database credentials, select Connect. Vero will automatically test the connection:
If there is a problem connecting to your database, please check your database credentials are correct and try again.
Vero currently supports direct connections. We are working to support Snowflake's "Data Sharing" functionality.
Vero will connect directly to your database over the public internet. By default, Snowflake accounts allow any client to connect to it. You can configure a Snowflake Network Policy with an IP whitelist to limit access to your Snowflake instance.
Vero will always make queries via the following IP address:
We recommend whitelisting access to your database via a single IP address.
After successfully connecting a Snowflake data source it can be used in any Newsletter to define an audience. Read about using SQL queries to generate an audience.
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.
Vero will show your query results in pages of 100 in the UI.
In order to load a full audience for use in a Newsletter, ensure you run your entire query (without a
Vero will currently timeout queries after 12 hours.