CODEWITHSUNDEEP
sqlsql-serversnowflake-cloud-data-platform
ROXOR7
ROXOR7

Reputation: 61

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

Upvotes: 0

Views: 8223

Answers (1)

Milney
Milney

Reputation: 6417

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

Upvotes: 1

Related Questions