Snowflake

Snowflake AI Integration

Data Warehouse

With Snowflake connected, your assistants can answer questions from tables, views, data shares, and schemas, within your Snowflake role permissions. Ask for total revenue by month this year or which customers haven't purchased in 90 days.

Access Mode
Read Only
Setup Time
~10 minutes
Auth Method
API Key
Available soon Read-only by default

Connect Snowflake to JoySuite

Your assistants query Snowflake with read-only access when someone asks.

Available soon. Setup takes about 10 minutes once it's ready.
Join Waitlist

What you can do

Getting an answer from the warehouse usually means writing SQL against schemas you may not know well.

Get a figure from your warehouse

"Show me total revenue by month this year"

Ask for a number such as monthly revenue and get the result from your tables.

See what's in a schema

"What tables do we have in the analytics schema?"

Ask which tables a schema contains and what they hold.

Find lapsed customers

"Find all customers who haven't purchased in 90 days"

List the customers who haven't purchased in a period you choose.

See a trend over time

"Show me the revenue trend over the last 12 months"

Ask for a metric over the last 12 months.

Query data shares

"Compare our sales with market data share"

Compare your data with data shared from other Snowflake accounts.

Combine warehouse data with your CRM

"What warehouse data relates to accounts in my CRM?"

See warehouse figures for the accounts in your CRM.

What Your Assistants Can Access

JoySuite securely connects to Snowflake, making these resources available to your assistants.

📊

Tables

Query structured data from your Snowflake tables.

Table Name Columns Row Count Schema Database
👁️

Views

Access pre-defined views and their query results.

View Name Columns Definition Schema
🔗

Data Shares

Query data shared from other Snowflake accounts.

Share Name Provider Objects Access
📁

Schemas

Browse database schemas and their objects.

Schema Name Tables Views Functions
⚙️

Functions

Access user-defined functions for complex queries.

Function Name Arguments Return Type Definition
📈

Query History

View recent query executions and their performance.

Query ID Duration Status Warehouse

Connector Commands

Use these specialized commands to interact with your Snowflake data directly in conversations.

/snowflake query

Query the Warehouse

Execute a SQL query against your Snowflake warehouse.

/snowflake table

Describe Table

View table schema, columns, and sample data.

/snowflake search

Search Data

Search across tables with natural language filters.

/snowflake schemas

List Schemas

Browse available schemas and their objects.

/snowflake preview

Preview Data

Get a sample of data from any table or view.

/snowflake stats

Get Statistics

Retrieve column statistics and data distribution.

Commands respect your permissions and access settings.

Connect Snowflake to Your Other Tools

See how Snowflake works with your other connected tools.

❄️
+
☁️

Snowflake + Salesforce Integration

Put Snowflake data next to Salesforce accounts when you ask about a customer.

❄️
+
📊

Snowflake + Tableau Integration

Combine Snowflake data with Tableau dashboards in one answer.

❄️
+
👁️

Snowflake + Looker Integration

Reference Snowflake data alongside Looker dashboards and Explores.

❄️
+
💬

Snowflake + Slack Integration

Find the warehouse figures behind topics your team discusses in Slack.

Permissions & Access Control

You control exactly what JoySuite can access within Snowflake.

Default

Read Access

Standard access level for querying Snowflake data.

  • Execute SELECT queries
  • View table schemas and metadata
  • Access views and data shares
  • Respects role-based access control
Not Available

Write Access

Write access is not available for this connector.

  • Snowflake is read-only by design
  • Data modifications require ETL
  • Query results are ephemeral
  • Full query audit logging
For your IT team Security & safety How JoySuite works with your LMS

Frequently asked questions

Does JoySuite store my Snowflake data?

No. JoySuite connects to Snowflake via API and queries data in real-time. Your data stays in Snowflake. JoySuite reads it from Snowflake when you ask a question and doesn't keep a copy.

Which tables and views can JoySuite access?

JoySuite can access data based on your Snowflake role permissions. It respects role-based access control (RBAC) settings.

Can JoySuite write to Snowflake?

No. The Snowflake connector is read-only by design. Data modifications should happen through your existing ETL processes.

How long does setup take?

About 10 minutes. Configure your Snowflake credentials, select the warehouse, and start asking questions about your data.

Does this work with data shares?

Yes. JoySuite can query Snowflake data shares, enabling you to combine your data with external shared data sources.

Related Connectors

Other connectors people use with Snowflake.

Tableau

Tableau

Data & Analytics
Looker

Looker

Data & Analytics
Power BI

Power BI

Data & Analytics
Salesforce

Salesforce

CRM & Sales

Connect Snowflake when it launches

Join the waitlist and we'll tell you when the Snowflake connector is available.

Join Waitlist