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 behavior with Snowflake.

Cause

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.