Why are boolean values different in source and warehouse? Values of a field have been converted from 0/1 in the Source to FALSE/TRUE in Snowflake
This is expected functionality of Snowflake.
In Snowflake, columns of type BOOLEAN can have TRUE or FALSE values. BOOLEAN can also have an “unknown” value, which is represented by NULL. More info in Snowflake Documentation.
If the data in the source is type boolean and has a value of 0/1, then this will need to be converted to FALSE/TRUE to be loaded to Snowflake.