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.