Why Are Boolean Values Different in Source and Destination?

Question

Why are boolean values different in source and destination? Values of a field have been converted from 0/1 in a 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. See for details.

If the source data has the type BOOLEAN and the value 0/1, it needs to be converted to FALSE/TRUE to be loaded to Snowflake.