Question 31 · 1323 in bank
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Show answer
Answer: A
Explanation
"Related to Using FLATTEN to List Distinct Key Names, you can use the FLATTEN function with the RECURSIVE argument to retrieve all keys and paths in an OBJECT." https://docs.snowflake.com/en/user-guide/querying-semistructured#using-flatten-to-list-paths-in-an-object
Source: Adapted from community discussion — Jacobr5000