Question
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
Environment
Destination: Snowflake
Answer
This is expected functionality of Snowflake.
Cause
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.