SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ69

Transform Data

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

Choose two
Explanation

GET retrieves an element from a VARIANT containing an OBJECT or ARRAY by field name or index, and nested values can be reached through chained calls. GET_PATH retrieves a value using a path name and is equivalent to a chain of GET functions.

Learn more

Community Discussion

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