Copilot + Snowflake
Connect Microsoft 365 Copilot to Snowflake
Ask Microsoft 365 Copilot questions about the data already in Snowflake. The Snowflake role you choose decides what the connector can read.
- Free app on Microsoft Marketplace
- Live, read-only SQL
- No Copilot Studio build
Official destination: marketplace.microsoft.com
Three steps
Connect Copilot to Snowflake
-
01
Open BlazeSQL on Microsoft Marketplace
The button above takes you straight to the BlazeSQL listing on marketplace.microsoft.com, so you don’t need to search for it.
-
02
Add the app for your account
Select Get it now and add BlazeSQL. If your organization asks for admin approval, send the listing to your Microsoft 365 admin and connect Snowflake in BlazeSQL while you wait.
-
03
Sign in and connect Snowflake
In Microsoft 365 Copilot, choose BlazeSQL and sign in. Then select Snowflake, enter the approved connection details and pick the data Copilot can use.
Before you start
What you need for Snowflake
- A Microsoft 365 Copilot license
- Snowflake account identifier
- Warehouse, database and schema names
- A Snowflake user and supported authentication details
- A role with access to the data you want Copilot to use
Optional but recommended
Create a read-only Snowflake login for Copilot
BlazeSQL already blocks queries that change data. A login that can only read adds a second safeguard. Replace the example names and password with your own.
CREATE ROLE blazesql_reader;
GRANT USAGE ON WAREHOUSE your_warehouse TO ROLE blazesql_reader;
GRANT USAGE ON DATABASE your_database TO ROLE blazesql_reader;
GRANT USAGE ON ALL SCHEMAS IN DATABASE your_database TO ROLE blazesql_reader;
GRANT SELECT ON ALL TABLES IN DATABASE your_database TO ROLE blazesql_reader;
GRANT SELECT ON ALL VIEWS IN DATABASE your_database TO ROLE blazesql_reader;
GRANT ROLE blazesql_reader TO USER your_blazesql_user;
Add the matching FUTURE grants if Copilot should also see tables created later.
Once connected
Questions you can ask Copilot about Snowflake data
Which regions are ahead or behind the current revenue forecast?
Explain the largest changes in gross margin this month.
Build a weekly funnel from acquisition through paid conversion.
Other ways to connect
How BlazeSQL compares with other Copilot options
-
BlazeSQL app
Add it from Microsoft Marketplace and ask questions straight away. Each question runs a new read-only query on live Snowflake data, so Copilot can answer with totals, trends and comparisons.
-
A custom agent in Copilot Studio
You can build your own database agent, but someone has to set up the connection, design the agent and maintain it.
For the rest of your team
Use the same answers in Teams and on the web
Colleagues without a Copilot license can ask questions about Snowflake in Microsoft Teams or the BlazeSQL web app. Business definitions you teach BlazeSQL once, like how you count active customers, apply everywhere.
Common questions
Copilot and Snowflake FAQ
Can Copilot connect to Snowflake?
Yes. Copilot can query Snowflake through the BlazeSQL connector using the account, warehouse, database, schema and role you choose.
Is the Copilot database connector free?
The BlazeSQL app is free to add from Microsoft Marketplace. Using it inside Copilot requires a Microsoft 365 Copilot license from Microsoft, and BlazeSQL itself may have plan limits for heavier use.
Do I need a Microsoft 365 admin?
Not always. If your organization restricts which apps people can add, a Microsoft 365 admin needs to approve BlazeSQL first. You can use BlazeSQL directly while you wait.
Can Copilot change data in Snowflake?
No. The connector only runs read-only queries. Statements that change data, such as UPDATE or DELETE, are blocked.
Ready to connect?
Connect Snowflake to Microsoft 365 Copilot
Continue to the official listing, add BlazeSQL and connect your database.