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

MainText>

subtext1>

Amount>555.02</Amount

</subtext

subtext2>

Address>4646 20th Ave</Adress

/subtext2>

/MainText>

I want to be able to extract the ‘4646 20th Ave’ data point.
So far I have the following
cast(GET(XMLGET(XMLGET((PARSE_XML(RAW_XML),’MainText’),’subtext2′)’@Address’) as varchar)
Any Ideas?