Snowflake connector for PowerApps and Power Automate

[VKrishna09]

Hello Microsoft Power Team!

Is there a possibility to get a direct Snowflake connector for PowerApps and Power Automate?

Power Bi already has one from 5 years! It's time to get this feature as snowflake usage is growing fast these days!

Anyone would like to add more or have a discussion on this?

[troystaylor]

Would this be the API you are requesting?:
https://docs.snowflake.com/en/developer-guide/sql-api/reference.html

[troystaylor]

No, I’m looking for clarification on if there is a REST API that a connector could be built for, and this seems to be the only API I can find. Do you have specific actions that you’d like to use with Power Platform?

[VKrishna09]

Snowpipe REST API can be built AFAIK! I have lots of data in Snowflake that needs to be used in the PowerApps(forms) we have.

[troystaylor]

So this API?:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-apis.html

[VKrishna09]

Yes!

[troystaylor]

You can give the following YAML a try with a custom connector. You will need to update the host name in the General tab for your host.
https://github.com/troystaylor/Testing/blob/aa56cd32adfaa69261fa8026527fa21cc839f9e4/Snowpipe.yaml
Like @Laskewitz mentioned, it is unlikely that this would be added as an Independent Publisher connector unless the preview connector isn't certified.

[Laskewitz]

There already is a Snowflake connector in preview: https://github.com/microsoft/PowerPlatformConnectors/tree/dev/custom-connectors/Snowflake

[VKrishna09]

Thats cool! Thanks for sharing! Will it be available as the other connectors are available in Power Platform in near future or do we have to follow this long manual process?

[Laskewitz]

For now, it's only available as a manual process. But I think it will be available in-product later. Maybe @natalie-pienkowska can expand on that!

[Erik-Douma]

Nice piece of work this custom connector.
Does anyone already have this working within PowerApps? Don't get the JSON data properly parsed in PowerApps. See only [object Object],[object Object],[object Object],[object Object],etc etc after a succesfull request.

[ausi-kh]

Any one has an example of using the custom connector for snowflake?
I am able to add the connector and call the executeSQL function, but cannot bind it to the view property of the powerapp objects