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

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

Any updates please?

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

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

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

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.

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!

Please!, provide an update when this be ready!

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.

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?

Is it a date in march when this feature is released?