Skip to main content
Microsoft Idea

Power BI

Completed

Snowflake connector -> add SQL statement as optional

Vote (427) Share
's profile image

on 17 Feb 2018 00:12:34

We'd like to be able to run a SQL statement in the Snowflake connector window

Administrator on 23 Jul 2021 23:32:29

The ability to write custom SQL is now available, to learn more about the connector details please visit: https://docs.microsoft.com/en-us/power-query/connectors/snowflake

Comments (75)
's profile image Profile Picture

Scott Cameron on 20 May 2021 22:21:58

RE: Snowflake connector -> add SQL statement as optional

Please add the ability to submit a custom SQL query to Snowflake.

's profile image Profile Picture

Juan Cedeno on 05 May 2021 15:09:47

RE: Snowflake connector -> add SQL statement as optional

Any updates please?

's profile image Profile Picture

Michael Hult on 13 Apr 2021 14:23:22

RE: Snowflake connector -> add SQL statement as optional

Looking for an update on this as well -- the planned & posted solution was not what the original idea was.

's profile image Profile Picture

Dominic Wackrow on 07 Apr 2021 04:01:36

RE: Snowflake connector -> add SQL statement as optional

You've changed the feature details in the linked planned case. Allowing custom SQL in the Snowflake connector is essential - please update us.

's profile image Profile Picture

Bruno Alexandro García Tejada on 29 Mar 2021 15:26:57

RE: Snowflake connector -> add SQL statement as optional

Will the custom SQL feature be added in the September 2021 Update?

https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave1/data-integration/navigator-performance-improvements-snowflake-connector

's profile image Profile Picture

PowerBI User on 26 Mar 2021 21:03:29

RE: Snowflake connector -> add SQL statement as optional

Any update on this? The link given by the Administrator no longer includes the requested feature (the ability to put custom SQL in the Snowflake connector) in the release plans. Please update this idea.

's profile image Profile Picture

Power BI User on 26 Mar 2021 14:15:49

RE: Snowflake connector -> add SQL statement as optional

The referenced march 2021 release is not wat is requested here.

Please add the ability to insert a SQL statement when connecting to Snowflake, like any other DWH (SQL/Oracle) connector does!

's profile image Profile Picture

Juan Cedeno on 22 Mar 2021 16:23:02

RE: Snowflake connector -> add SQL statement as optional

Please!, provide an update when this be ready!

's profile image Profile Picture

Paul Stevens on 18 Mar 2021 18:41:24

RE: Snowflake connector -> add SQL statement as optional

The Microsoft docs link from the Administrator originally indicated Custom Role and Native SQL features in the connector release; as of March 18th, that link indicates only the Custom Role support.
"The Snowflake connector will add support for custom roles. This will allow users to have much greater specificity in returning the required data."

@Microsoft and Administrator, please update the status of this Idea if it is no longer Planned, or add an updated link and information for the planned feature.

This is a high priority feature for Power BI to efficiently connect to Snowflake and minimize Snowflake credit cost.

's profile image Profile Picture

Dev Praha on 15 Mar 2021 09:04:15

RE: Snowflake connector -> add SQL statement as optional

Snowflake custom SQL query has NOT been released as part of the March 2021 update (only the ROLE has been added). When will this be released @Microsoft?

Merged Idea (2)