cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jozumfoen
‎05-22-2025
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Why are VARCHAR lengths from Snowflake tripled in SAS DI Studio?

by Calcite | Level 5 in SAS Data Management
‎05-22-2025 09:20 AM
‎05-22-2025 09:20 AM
Hi everyone, I’m accessing Snowflake tables through SAS Data Integration Studio using the Snowflake connector. When I register  table from Snowflake in SAS DI, I noticed that VARCHAR(n) columns are automatically assigned LENGTH=3n in SAS metadata. For example: VARCHAR(2) becomes LENGTH=6. Why does this happen, even though both systems use UTF-8? Thanks in advance! ... View more

Why are VARCHAR lengths from Snowflake tripled in SAS DI Studio?

by Calcite | Level 5 in SAS Data Management
‎05-22-2025 09:03 AM
‎05-22-2025 09:03 AM
Hi everyone, I’m accessing Snowflake tables through SAS Data Integration Studio using the Snowflake connector. When I register  table from Snowflake in SAS DI, I noticed that VARCHAR(n) columns are automatically assigned LENGTH=3n in SAS metadata. For example: VARCHAR(2) becomes LENGTH=6. Why does this happen, even though both systems use UTF-8? Thanks in advance! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-22-2025 08:57 AM
Quick links