Snowflake connector -> add SQL statement as optional

[jbh3]

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

[jmorrow1]

This is crucial. Refreshes with big Snowflake tables are consuming credits when not necessary. The workaround is to create custom views of specific tables on the Snowflake side which creates much more work. A simply query would greatly improve the effectiveness of this connector.

[VMazunin]

Snowflake connector needs to be functional as soon as possible. Ability to run custom queries against Snowflake is critical, as well as ability to use Azure SSO to connect to Snowflake Cloud2Cloud without ODBC driver.

[Artur_Skirdin1]

This should be implemented. Otherwice, not having SQL statement option limits significatly the ability to work with large datasets.

[regan1]

great to see this on the roadmap now! https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/cdm-data-integration/snowflake-connector-enhancements-power-query-desktop "The Snowflake connector will add support for custom roles and native queries. This will allow users to have much greater specificity in returning the desired data." "General Availability March 2021"

[juan_Cedeno]

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

[pete_praha]

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?

[paul_stevens1]

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.

[juan_Cedeno]

Please!, provide an update when this be ready!

[ferry_bouwman]

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!

[Carlos_Cueto]

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.