reubwork's avatar
reubwork
Icon for Resolver I rankResolver I
1 year ago
Status:
New

May 25 update for Snowflake Connector v2 has broken native queries involving boolean data

Since the May release, any native query using a Snowflake Connector v2.0 connection experiences boolean type conversion errors on refresh. 

 

let
    Source = Snowflake.Databases("<snowflake account url>","<warehouse name>",[Implementation="2.0"]),
    data = Value.NativeQuery(
                Source{[Name = "<database name>",Kind="Database"]}[Data],
                "select false as v union all select true as v"
                , null
                , [EnableFolding = true]
            )
in
    data

 

The preview in Power Query is fine, but the error is presented when dataset is refreshed. 

 

 

Additionally, converting the datatype in power query doesn't work. 

 

 

I suspect a workaround will be to convert the data to 1,0 values either in the snowflake query or via a text step in powerquery

 

This seems to be, though, to be an unintended and relatively serious breaking change. 

 

 

 

 

3 Comments