Convert a message attribute of a log (that is a array of JSON) to a table

Hi there!

I have logs that have a list of client information (JSONs) in the message attribute. Something like this:

[{"id":"1","name":"Company 1","country":"USA",},{"id":"2","name":"Company 2","country":"CAN",}]

I want to create a table from this message. A table like this:
Colum headers: id; name; country
First-row data: 1; Company 1; USA
Second-row data: 2; Company 2; CAN

Can someone help me to do this?

I tried a couple of things. The one that approximates the most is doing this query:

SELECT id, name, country
FROM Log
WITH aparse(message, '%{"id":"*","name":"*","country":"*"},%') AS (id, name, country) 

But I’m getting only the first row. In the example I’m getting this:
Colum headers: id; name; country
First row data: 1; Company 1; USA