Access JSON strings with different keys using Databricks SQL
I have a array with JSON strings and each JSON has a different key. Also, the size of the array is not fixed and may increase or decrease in occurrences. An example of this is below : "[{"key1": 10},{"key2":"val2"}]" I…