on 17 Feb 2018 00:12:34
We'd like to be able to run a SQL statement in the Snowflake connector window
- Comments (49)
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.
RE: Snowflake connector -> add SQL statement as optional
This is definitely needed in Snowflake. It would be vital for them if they want to stay competitive and eliminate the competition.
RE: Snowflake connector -> add SQL statement as optional
Someone should seriously look into this. There is an increasing number of organisations moving into Snowflake. We already know Snowflake has a good relationship with Tableau. So we really like PowerBI to be up there & get these basic level of functionality in as quickly as possible. Its not too late but your brand loyal customers are helpless & bit frustrated with this already. Thank you
RE: Snowflake connector -> add SQL statement as optional
Yes this is a vital component to using Power BI within our business, without this we may need to switch to Tableau. Please add this into production ASAP.
RE: Snowflake connector -> add SQL statement as optional
We need this function too.
Should be standard imho.
RE: Snowflake connector -> add SQL statement as optional
we need this please please please
RE: Snowflake connector -> add SQL statement as optional
please, my organization needs this feature