Spark wrongly map the BOOLEAN Type to BIT(1) in Snowflake

In Snowflake the Boolean type is represented by the Boolean data type (https://docs.snowflake.com/en/sql-reference/data-types-logical), but Spark rely on the default JdbcDialect to generate the mapping which maps Boolean to BIT(1)

This should be probably handled by a dialect specific to Snowflake.