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:

Select Snowflake database

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).
  • Username.
  • Password.
  • 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:

  • Schema.
  • Role.

Snowflake connection options

We recommend including a role. If a role is not provided Snowflake will default to the public role that all users have access to.

Including a schema helps narrow down the list of available tables presented in Vero's query interface:

Example of Snowflake query interface

Database permissions

Vero will only execute SELECT queries against your database. It is read only by design. We recommend creating a unique user and 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 usage rights 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 role is recommended. Without a role Snowflake defaults to the public role. As a result, any databases, tables or other resources that are accessible via the public role 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:

Snowflake testing connection

If there is a problem connecting to your database, please check your database credentials are correct and try again.

Connection security

Vero currently supports direct connections. We are working to support Snowflake's "Data Sharing" functionality.

IP whitelisting

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: 3.208.52.255.

We recommend whitelisting access to your database via a single IP address.

Next steps

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.

FAQs

Query limits

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 LIMIT clause).

Query timeout

Vero will currently timeout queries after 12 hours.

Author

  • Chris Hexton
    CEO and Co-Founder