DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ57

VerifiedOfficial exam objectives/topics

When working with semi-structured data in a VARIANT column, which Snowflake functions let a user write queries that extract values using a hierarchy name?

Choose two
Explanation

GET retrieves an element from a VARIANT value by the specified path element, while GET_PATH retrieves a value using a path name and is equivalent to a chain of GET calls for hierarchical data.

Learn more

Community Discussion

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