How to Integrate Snowflake with Power Apps?

(1) Share

Report

Posted on by CU22051417-0

Hi everyone,
I'm trying to integrate Snowflake with Power Apps, but I'm not sure about the best approach. Ideally, I want to be able to read/write data from a Snowflake database directly within a canvas app.
I’ve considered a few options:
Using Power Automate with an Azure Function or custom connector
Exposing Snowflake data via an API (e.g., through Azure API Management or a custom service)
Using ODBC/JDBC connectors, but unsure how that fits into Power Apps
Has anyone successfully implemented this? What method did you use, and what were the challenges or limitations?
Any guidance, code samples, or reference architectures would be appreciated.
Thanks in advance!

Categories:

Power Apps component framework

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

NarsimhaCBanala 2 on at

Like (0)

Report
How to Integrate Snowflake with Power Apps?

You can integrate Snowflake with Power Apps using the Snowflake Connector for Microsoft Power Apps, but unlike standard connectors, it works through Dataverse virtual tables. This means you need to expose Snowflake tables as virtual tables inside Dataverse, and then you can use them for read/write (CRUD) operations within your canvas or model-driven apps. You can go through this step-by-step guide: Supercharging Power Apps with Snowflake: A Step-by-Step Guide | LinkedIn

Key steps:

Configure OAuth integration in Snowflake to enable secure authentication.

Set up the Snowflake connector in Power Platform Admin Center.

Create virtual tables in Dataverse that map to your Snowflake tables.

Use these virtual tables directly in Power Apps for queries, inserts, updates, and deletes.

Here is the virtual table created and added to Canvas app and Model-Driven app to perform CRUD operations in Snowflake,

Resources:

Step-by-Step Blog Guide

Official Snowflake Docs – Power Apps Connector

Snowflake - Connectors | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

Power Apps 1919 1,303 on at

Like (0)

Report

How to Integrate Snowflake with Power Apps?

Hi @CU22051417-0,
you can use Snowflake connector with Power Automate flows + Snowflake (JS Store Procs) which can help in your app building.
Only Problem is you have always return Data from Snowflake Store proc as Array Data Type not Variant Data Type.

And for editing data using Same approach send the data from flow to snowflake proc which writes back (best way I used is, I sent the records as Json array and parsed it in snowflake and did the processing)
one problem I faced during this step (rare case) is if your data has single quote or double quote your process might fail.
workaround for that is: send the base64 string of the Json and decode the base64 in snowflake and do the operation.

Why this Approach?
1. No need to use dataflows (which is very slow depending on data size and data duplication and dataverse storage costs etc...).
2. No need for Virtual tables (as per this doc : Snowflake - Connectors | Microsoft Learn ,i tried virtual table and most formula like filter didn't work for me).
3. As we are using Store Procs, we can control and customize it as we like).
4. No need for Third party options.

Please give the mentioned solution a try and let me know whether it works for you.
If it solves your issue, feel free to mark this thread as answered.
Please make sure to like the response!
Thanks!
- Hemanth Sai

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 48,842 Super User 2025 Season 2 on at

Like (0)

Report

How to Integrate Snowflake with Power Apps?

Hi @CU22051417-0

The best approach is to use the new preview connector

Snowflake - Connectors | Microsoft Learn

Its just like any datasource. Simply say add Data, Select the Connector and add the data you need.

There is no... reference architecture etc around connectors really. If they exist, you would use them, if not you can create a custom one, or the use HTTP connector.

Of course this is a premium connector and nothing can be done about that cost wise, so everyone will need a premium license to use the app.

Within reason, connectors can be used the same in Apps as they are in Flows. So fortunately you dont need to call a flow.

Now if you look at overall things like... Retries (use flows), long running t hings (flows), not wanting the user to wonder WTF is going on, use flows and or at least some type of "Processing ...." overlay screen.

Always pay attention to if they are Standard (free) or Premium (paid) as every user will need that type of license.

Was this reply helpful? Yes No