I am trying generate a report with a SQL with JSON_TABLE, but SC generate a error with '$.envio[]’. SC believes that is a global variable ( [] ).
SELECT
jt.id_envio,
jt.fecha_envio
FROM pedidos p,
JSON_TABLE(
p.json_data,
‘$.envio[*]’
COLUMNS (
id_envio INT PATH ‘$.id’,
fecha_envio DATE PATH ‘$.fecha’
)
) AS jt