on 7/23/2021 11:32:29 PM
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
For me the snowflake connecter is all but useless without this!
This is criticallly needed so parameters can be passed to execute the query on the DB tier. Bringing back large tables with billions of rows is not feasible
would love to see this feature, AND have the ability to add dynamic parameters!!
I've seen it's possible to achieve this through the ODBC connector, but it would be more convenient to have it in the Snowflake connector