SnowPro Core RecertificationRetired

By Snowflake · Question Mode

QuestionQ25

VerifiedData Loading and Transformation

What are the potential effects of storing non-native values, such as dates and timestamps, in a Snowflake VARIANT column?

Explanation

Non-native date and timestamp values loaded into a VARIANT column are stored as strings. Relative to relational columns that use the corresponding native data types, operations on those values can be slower and consume more storage.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!