Hey, I’m facing difficulties to unnest and extract values from my dataset which has json columns as varchar.
I know that the first thing I have to do is to convert the varchar to json with CONVERT_FROM(‘varchar’ , ‘JSON’) and then exctract the values that I want with “SELECT table.column.key1 FROM table_converted_with_jsons”. Am I right?
So, here’s the error in step 1 with the following query:
→ “select convert_from(request, ‘json’) from PaymentAudits limit 1”
→ (It takes some seconds and then shows the message: “New field in the schema found. Please reattempt the query. Multiple attempts may be necessary to fully learn the schema.”
I reattempted many times and I put just 1 row to test if the problem was with inconsistency of the data in the same column through the rows, but apparently the problem isn’t it and we aren’t changing the schema untill I know.
And this is the query profile:
Does anyone know what it is happening?
Thanks in advance!