So I have a table as such: I would like to restructure this data so that each list element becomes its own row. If VALUE is an empty list, the expectation is it does not appear in the final dataset. Final result should be: I think using FLATTEN() in Snowflake should work here but I cant seem to get it.
Tag: flatten
Flatten multiple names arrays within variant json column in snowflake
I have a web scraper dumping data into a variant column in a Snowflake database. This is acraping page data as then creates json arrays for various tables found within the page. Here is an example of the type of json i would find using a Soccer analogy: Ideally, i’d like the output of this to be a flat, relational