Snowflake

Source + Destination — Vendo connects directly to your Snowflake warehouse. No data is copied or moved — queries run in your environment, and results are used in real time for models, audiences, and AI.

Key Benefits

Zero-Copy Access — Query your Snowflake tables directly. Data never leaves your warehouse.
No Data Movement — No ETL, no staging tables, no storage duplication.
Role-Based Access — Use Snowflake roles to control exactly what Vendo can see.
Full SQL Support — ANSI SQL queries for models, transformations, and exploration.

How It Works

Vendo connects to Snowflake using credentials you provide (username/password or key-pair authentication). When you run a model, build an audience, or ask the AI a question, Vendo executes SQL directly against your Snowflake warehouse and processes the results in memory.

No data is stored by Vendo. Query results are used in-flight and discarded after processing.

Authentication Methods

Method	Description
Username + Password	Standard Snowflake user credentials. Simplest to set up.
Key-Pair (RSA)	More secure. Upload an RSA private key — no password needed. Recommended for production.

What You Need

A Snowflake account with a virtual warehouse
A database and schema to query
A user with read access (and optionally write access for destinations)
The account identifier from your Snowflake URL

Platform Details

Setting	Value
Connection Method	Snowflake Node.js SDK
Query Execution	Direct SQL on your warehouse
Authentication	Username/password or RSA key-pair
Data Storage	None — zero-copy
IP Whitelisting	Available (contact support for static IPs)

What to Expect After Setup

Connection Verified — Vendo tests connectivity and lists your schemas
Schema Browser — Browse databases, schemas, and tables in the Vendo UI
Query Ready — Run SQL queries, build models, and create audiences immediately
No Sync Needed — Data is always fresh because queries run directly

Setup Instructions