Forum Discussion

TimHoare's avatar
TimHoare
Frequent Visitor
2 years ago

Direct query limitations with the Snowflake connector

I have a report that connects to a Snowflake database via direct query, and a measure that calculates the median of a column. Because MEDIAN is a function that is supported in Snowflake, ideally the ...
Need Help
jeffshieldsdev's avatar
jeffshieldsdev
Solution Sage
2 years ago

Update the Snowflake query to use native SQL, something like:

let
    Source = Value.NativeQuery(
        Snowflake.Databases("server", "warehouse", [Role="role"]){[Name="database"]}[Data],
        "
sql
        ",
        null,
        [EnableFolding=true]
    )
in
    Source

and use MEDIAN() function that way.