Skip to content
Advertisement

Snowflake BIT datatype

i have BIT data type in sql server and i am trying to migrate it to snowflake but i am not able get the data into snowflake properly 0 goes as 0 but 1 goes into as 255 when i DT_UI1 data type to output the column in sql server

can anybody help me how to send bit data type column to snowflake

Advertisement

Answer

DT_UI1 is probably an unsigned integer and you want a regular signed integer.

Failing that you can just select instead

CASE WHEN [BitColumn] = 1 THEN 1 ELSE 0 END

or

CAST([BitColumn] AS INT)

To get an integer on the source side

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement