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)
- Merged Idea (2)
RE: Snowflake connector -> add SQL statement as optional
Is it a date in march when this feature is released?
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"
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.
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.
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.
RE: Snowflake connector -> add SQL statement as optional
This is such an important feature that is missing for Power BI
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.
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.
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?
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.