Snowflake

Last updated: September 8, 2025

Connect Zams to your Snowflake data warehouse using OAuth. Just provide your Snowflake account subdomain, complete the OAuth flow, and you can run queries, explore schemas, and export results — all via natural language.

Connection Method

  • Type: OAuth 2.0 (via a Security Integration in Snowflake)

  • Requirements:

    • Your Snowflake account subdomain (e.g. myorg.us-east-1)

    • A Snowflake OAuth security integration set up by your administrator

Available Functionalites

Funcionality

Description

Run query

Execute custom SQL queries against your Snowflake warehouse.

List DB Objects

Browse available databases, schemas, and tables.

Get Table Schema

Retrieve column definitions, data types, and metadata for a table.

Export Query Results

Download query results as CSV or JSON for analysis or reporting.

Example of Use

  • Run an analytical query

“@Snowflake run SQL query: SELECT COUNT(*) FROM sales.transactions WHERE transaction_date > '2025-01-01'.”

  • Browse data structures

“@Snowflake list databases in my account.”

  • Inspect a table

“@Snowflake what’s the schema for table analytics.customer_profiles?”

  • Export results

“@Snowflake export the result of SELECT * FROM marketing.leads LIMIT 100 as CSV.”