Skip to main content

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

Juan Cedeno on 09 Mar 2021 14:33:05

RE: Snowflake connector -> add SQL statement as optional

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

's profile image Profile Picture

Regan Murphy on 19 Nov 2020 03:28:40

RE: Snowflake connector -> add SQL statement as optional

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"

's profile image Profile Picture

Artur Skirdin on 30 Oct 2020 20:51:35

RE: Snowflake connector -> add SQL statement as optional

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

's profile image Profile Picture

Vlad M on 02 Oct 2020 20:21:20

RE: Snowflake connector -> add SQL statement as optional

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.

's profile image Profile Picture

Jake Morrow on 18 Sep 2020 18:04:37

RE: Snowflake connector -> add SQL statement as optional

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.

's profile image Profile Picture

Sreedhar Nagandla on 17 Sep 2020 16:14:59

RE: Snowflake connector -> add SQL statement as optional

This is such an important feature that is missing for Power BI

's profile image Profile Picture

T Fisher on 18 Aug 2020 11:18:48

RE: Snowflake connector -> add SQL statement as optional

This feature is available in Tableau, not in PBI.
Important to only load specific data from large datasets in SnowFlake.

's profile image Profile Picture

Ronald Swan on 05 Aug 2020 19:11:33

RE: Snowflake connector -> add SQL statement as optional

Need the ability to make a Snowflake data connection, Import and Direct Query-abled, using the Snowflake connector in PowerBI, but utilizing custom SQL.

Would also like to make sure, if Import is used, that queries can fold keeping it Incremental Refresh capable.

's profile image Profile Picture

Brian Lee on 28 Jul 2020 14:54:04

RE: Snowflake connector -> add SQL statement as optional

Snowflake Custom queries are a critical need for us. The inability to specify the desired data precisely means we would end up producing heavy Snowflake consumption unnecessarily, which is costly both in time and money. Alternatively using Snowflake views to manage content isn't really appealing either -- creates an administrative nightmare. ODBC provides for custom queries, but the admin of all the ODBC connections is not desirable either.

I'm not sure why you would release ANY connector that does not provide for custom SQL. Is there any timeline on when this feature could be added?

's profile image Profile Picture

Tim Heckel on 22 Jul 2020 22:31:48

RE: Snowflake connector -> add SQL statement as optional

This feature is essential. Having to create and manage all of our companies queries (views) at the Snowflake level for each report is a nightmare.

Merged Idea (2)