MSCEWI2051
Teradata BYTES function results differs from Snowflake LENGTH function for byte columns
Last updated
Teradata BYTES function results differs from Snowflake LENGTH function for byte columns
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
Since Teradata byte datatype has a fixed length, BYTES function inserted to fit smaller byte type values into the column, returning the size of the column instead of the size of the value inserted originally. However, Snowflake binary type has variable size, meaning that the LENGTH function will always return the size of the inserted values. Take the following code as an example:
Teradata:
Equivalent code in Snowflake:
Analyze the use given to the BYTES function results, maybe the Snowflake LENGTH function behavior was the one desired from the start and no changes are required.
If you need more support, you can email us at