"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
A
https://docs.snowflake.com/en/sql-reference/functions/flatten
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Jacobr5000
6 months agoNachoPrendes
8 months, 2 weeks ago