'Creating Nested Array from VARCHAR in Snowflake
I'm having trouble casting a structured VARCHAR to a nested array in Snowflake.
Each VARCHAR has the format:
[['item1a', 'item1b', 'item1c', 'item1d'], ['item2a', 'item2b', 'item2c', 'item2d'], ..., ['itemNa', 'itemNb', 'itemNc', 'itemNd']]
where there are N arbitrary arrays (all of length 4) in the outer array.
Can someone give me a hint on the SQL I'd used for this? I'd also ideally like to get rid of the single quotes surrounding each element.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|