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 behavior with Snowflake.
In Snowflake, columns of type
BOOLEAN can have
TRUE/FALSE values. They 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.