"Unsupported data type 'bit'." when writing a Binary Field to Snowflake

[saqib]

Hello,

I am trying to write to a Snowflake DB using DB Writer node. But whenever there is a Boolean Fields, the DB Writer node throws the following error:
ERROR DB Writer 0:149 Execute failed: SQL compilation error:
Unsupported data type ‘bit’.

Any ideas on how to fix this issue?

Thanks!

[ipazin]

Hi there @saqib,

just to check - which type is your KNIME column and which type is your Snowflake column? Anyways there is Output Type Mapping tab where you can define mapping for specific column(s) or change defaults. Currently KNIME Boolean is mapped to DB Boolean (obviously).

Br,
Ivan

[saqib]

Thanks @ipazin ! Changing the Output Type Mapping to Boolean, fixed the issue. Thanks!