[SPARK-44866] Spark wrongly map the BOOLEAN Type to BIT(1) in Snowflake

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.1
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Hayssam Saleh
• Reporter: Hayssam Saleh
• Created: 18/Aug/23 09:20
• Updated: 12/Mar/24 14:44
• Resolved: 08/Sep/23 22:14

Description

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.

Issue Links

• links to: [Github] Pull Request #42545 (hayssams)
• links to: GitHub Pull Request #42545