So I understand that there is a 16MB limit when loading XML files into variant column within Snowflake.

I’m new with extracting data point from XML with SNowflake.
I’m looking for help in extracting data from the following example:

I’m new with extracting data point from XML with SNowflake.
I’m looking for help in extracting data from the following example:

Below is my XML data

I have this query here in snowflake and its ouput