View Categories

How to Connect Snowflake to Excel – Stream Live Data Warehouse Analytics

4 min read

CONNECTOR GUIDE

Snowflake ➤ Microsoft Excel

Snowflake Snowflake
Query Streams Query Streams
Microsoft Excel Microsoft Excel
Cloud Native
Live Data
Secure
See everything Query Streams can do beyond this guide Get Started Free
Supports
SQL Server PostgreSQL MySQL MariaDB SQLite MS Access Oracle BigQuery DuckDB
+more
Excel Sheets
Live Data

Replace exports with on-demand SQL

Excel Sheets
Nova
BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova
REST API
Database REST API

One key per partner. No credentials shared.

Build an API
Airtable Smartsheet Baserow SeaTable +more
Automation

Scheduled sync to 6+ platforms

Explore
Stripe HubSpot Shopify GA +more
API to SQL

Query APIs with SQL, no code

Explore
MCP Claude Cursor ChatGPT Grok +more
AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams enables you to connect Snowflake Data Warehouse directly to Microsoft Excel, streaming live cloud data without ODBC drivers, VBA scripts, or complex configuration. Sign up for free at QueryStreams.com and start pulling live warehouse data into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your Snowflake data warehouse and Microsoft Excel. Whether you’re analyzing marketing data, building executive dashboards, or sharing analytics with stakeholders worldwide, Query Streams provides a simple solution for accessing your cloud data warehouse.

Cloud Data Warehouse

Connect to Snowflake’s elastic compute and storage

Real-Time Warehouse Queries

Execute Snowflake SQL and stream results instantly

Secure Credential Storage

Credentials stay on your network, never exposed

Multi-Region Support

Works with any Snowflake region worldwide

What You’ll Accomplish

By the end of this guide, you’ll be able to:

  • Connect Excel to Snowflake – Cloud data warehouse access
  • Execute Snowflake SQL in real-time from Excel
  • Build live warehouse dashboards with auto-refreshing data
  • Share secure warehouse access with stakeholders globally

Prerequisites

1

Query Streams Account

Create a free account to get started with Snowflake integration.

Create Free Account →
2

Query Streams Agent Installed

Install the agent on any network location (Snowflake is cloud-based).

Install the Query Streams Agent →
3

Snowflake Account Access

Snowflake account identifier, username, and password with query permissions.

Find Account Identifier →
Cloud-Native: Snowflake is cloud-based, so the agent connects over the internet. Ensure your agent has outbound internet access to reach your Snowflake account.

Step 1: Access the Query Streams Agent Interface

1
2
3
4
5
6
7

With your agent installed, configure your Snowflake connection.

  1. Open your web browser and navigate to: https://localhost:1823
  2. Navigate to Data Connections: Click Data Sources > Connections
  3. Add a new connection: Click Add Connection

Step 2: Select Snowflake as Your Connection Type

2
3
4
5
6
7
  1. Choose Snowflake: Click on the Snowflake tile (green border when selected)
  2. Alternative – Use search: Type “Snowflake” to quickly find it
  3. Click Next to proceed

Step 3: Configure Your Snowflake Connection Details

3
4
5
6
7

Required Snowflake Connection Details:

  1. Connection Name – Friendly name (e.g., “Snowflake Warehouse”)
  2. Account Identifier – Your Snowflake account ID (e.g., KOCIDTQ-DK94312)
  3. Region (optional) – Region if not in account ID (e.g., us-east-2.aws)
  4. Warehouse (optional) – Compute warehouse name
  5. Database – Snowflake database name
  6. Schema (optional) – Default schema (defaults to PUBLIC)
  7. Role (optional) – Snowflake role for this connection
  8. Username – Snowflake username
  9. Password – Snowflake password

Once completed, click Next.

Security: Snowflake credentials are stored securely within the Query Streams agent on your network and are never exposed to end users or transmitted to Query Streams cloud services.

Step 4: Select Your Data Realm

4
5
6
7

Select your Data Realm – your query processing capacity.

  1. Review available realms: Based on your subscription
  2. Select realm: Choose “Default Data Realm”
  3. Click Next to test the connection

Step 5: Test Your Snowflake Connection

5
6
7

Query Streams will verify your Snowflake credentials.

  1. Automatic testing: Agent attempts to connect to Snowflake
  2. Review results: Success shows Snowflake version, warehouse, and permissions
  3. Click Next if successful
Troubleshooting: If connection fails, verify account identifier is correct, credentials are valid, and your agent has outbound internet access to reach Snowflake.

Step 6: Finish Setup

6
7
  1. Review configuration: Verify all settings are correct
  2. Click Finish to save your Snowflake connection

Your Snowflake connection is ready! Next, install the Excel add-in.

Step 7: Install Add-In and Run Your First Query

7

Install the Query Streams add-in from Microsoft AppSource:

Install Query Streams for Excel

After installation, open the add-in from the Home ribbon tab and create your first Snowflake query:

  1. Click “Stream a Query”
  2. Select your Snowflake connection
  3. Choose database and schema
  4. Write your Snowflake SQL:
Example Snowflake Query SQL 
SELECT 
    customer_id,
    customer_name,
    email,
    total_purchases,
    country
FROM customers
WHERE total_purchases > 1000
ORDER BY total_purchases DESC
LIMIT 100;
  1. Configure destination: Choose “Create a new tab”
  2. Click Play to execute
Excel Versions Supported: Query Streams works with Excel for Microsoft 365 (Windows/Mac), Excel Online (web browser), and Excel 2016/2019 on Windows.

Success!

You’ve connected Snowflake to Excel! Your cloud warehouse data streams instantly into a new worksheet. Re-run anytime for the latest analytics.

Next Steps: Save and Share Queries

Use the Query Streams web portal to build, save, and manage your Snowflake queries:

  • Save queries: Store warehouse queries for reuse
  • Add parameters: Create dynamic filters for data exploration
  • Share globally: Let stakeholders run queries from anywhere
  • Access from add-in: Saved queries appear in “Saved Queries” menu

Frequently Asked Questions

❓ Is Query Streams better than Excel’s built-in Power Query? +

Query Streams complements Power Query with key advantages: no ODBC connector setup, works across Windows/Mac/Web, supports secure sharing without exposing Snowflake credentials, and enables real-time warehouse access.

🔒 Is my Snowflake data secure? +

Yes. Snowflake credentials never leave your network – they stay within the Query Streams agent. Data is encrypted in transit, and the agent makes only outbound connections (no firewall changes required).

☁ Which Snowflake regions are supported? +

All Snowflake regions are supported – AWS, Azure, and Google Cloud. Simply provide your account identifier and region during configuration.

👥 Can I share queries with external users? +

Yes! Share saved queries with external users who can run them from anywhere – they’ll get live data without ever seeing your SQL or Snowflake credentials.

💰 Will this increase my Snowflake costs? +

Query Streams executes standard Snowflake SQL, so you’ll incur normal warehouse compute costs. Use LIMIT clauses and optimize queries to control Snowflake credit usage.

💻 Does Query Streams work with Excel for Mac? +

Yes. Query Streams works with Excel for Microsoft 365 on macOS. The Excel add-in supports all major platforms including Windows, Mac, and Excel Online in the browser.

Snowflake Guides

Other Database Connections

Getting Started

Updated on June 3, 2026
automation database-integration excel no-code snowflake

What are your Feelings

  • Happy
  • Normal
  • Sad

Powered by BetterDocs