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

[reubwork]

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. 

[aaron_toledo]

I am experiencing the same issue. Converting to 0,1 does fix the problem but is not ideal as an extra step. Another option that seems to work is removing the Implementation="2.0" setting

[reubwork]

Yes, reverting to Implemenation=1. 0 works also. The trouble is that as of the March 25 release v2.0 is enabled by default in the options... so the boolean issue is now a breaking change.