Snowflake

Snowflake is a managed source integration. Vendo-led setup connects a dedicated role and warehouse so supported workflows can query approved tables and views.

What the connection provides

• Discovery of approved databases, schemas, tables, and views.
• Read-only SQL through the selected virtual warehouse.
• Snowflake-native role controls and query history.
• Use of query results in agreed Vendo analysis and transformation workflows.

Before requesting setup

• Snowflake organization/account identifier and region.
• Virtual warehouse.
• Database, schemas, and required objects.
• A dedicated Vendo role and user or service principal.
• Authentication and network-policy requirements.
• Expected workload and warehouse cost controls.

Access model

Grant warehouse usage, database/schema usage, and SELECT only on the required objects. Prefer key-pair or another organization-approved service authentication method over a shared human password.

Setup and verification

Follow Managed Snowflake setup. The connection is ready when Vendo lists only the approved objects and a bounded result matches a query run in Snowflake.

Related

• Custom Integrations
• Transformations
• SQL Editor