I have this query here in snowflake and its ouput
SELECT
t.id AS transcript_id,
section.value::string AS section,
XMLGET(section.value, '$')::string AS section_content
FROM FACTSET_OPEN_ACCESS__RD.TRANSCRIPTS.TRANSCRIPTS_OPEN t,
LATERAL FLATTEN(input => XMLGET(t.raw_xml, 'body'), path => 'section') section
WHERE t.id = 2676505;
| TRANSCRIPT_ID | SECTION | SECTION_CONTENT |
|---|---|---|
| 2676505 | 0 | NULL |
| 2676505 | 1 | NULL |
I know for sure the xml is correct and the table is correct and yet the xml content for section is producing NULL.