Snowflake

Source (Direct Connection) - Vendo reads directly from your Snowflake warehouse. No data is copied into Vendo’s infrastructure.

What Vendo Accesses

Vendo connects to your Snowflake account and queries authorized tables for attribution, segments, SQL models, and AI-assisted analysis.

Data	Description
Tables	Any table the configured role can read
Views	Standard and secure views
Materialized Views	Precomputed warehouse views
Schemas	Database schemas granted to the Vendo role

Behavior	Description
Direct Query	No import job is required; queries run in your Snowflake warehouse
Role-Based Access	The configured Snowflake role controls visible databases, schemas, and tables
Password or Key-Pair Auth	Supports username/password and RSA private-key authentication
Schema Discovery	Vendo discovers readable schemas and tables after the connection is saved

Setting	Value
App type	`snowflake`
Connection type	Direct connection (no sync)
Auth method	Username/password or RSA key-pair
Compute	Queries run on your Snowflake virtual warehouse

Navigate to App Connections > Add App Connection
Select Snowflake from the data warehouse category
Enter your Snowflake account identifier, warehouse, database, and default schema
Enter the role, username, and either a password or private key
Save the connection so Vendo can test connectivity and discover schemas

Field	Description
Account Identifier	Snowflake account identifier, such as `xy12345.us-east-1` or `orgname-accountname`
Warehouse	Virtual warehouse used to execute queries
Database	Default database to connect to
Schema	Default schema; leave empty to use `PUBLIC`
Role (Optional)	Snowflake role to assume; leave empty to use the user default
Username	Snowflake user with read access to the target data
Password	User password when using password authentication
Private Key (Optional)	RSA private key in PEM format when using key-pair authentication

Grant the Vendo role the smallest read scope needed for the data you want to use:

Permission	Purpose
`USAGE` on warehouse	Execute queries
`USAGE` on database and schema	Discover and address objects
`SELECT` on tables or views	Read source data

Snowflake is also available as a destination for warehouse activation. It accepts event, user, ad data, and conversion exports from Vendo.

See Snowflake destination setup for write-access setup notes.

Symptom	What to check
Connection fails	Confirm the account identifier, warehouse, database, and username are correct
Tables do not appear	Check `USAGE` on the database/schema and `SELECT` on the target tables
Query is slow	Queries run on your virtual warehouse; resize or resume the warehouse if needed
Network policy blocks access	Contact Vendo support for static IPs to allow in Snowflake network policies