Currently, XMLs and JSONs are loaded into Snowflake as a Variant data type. I'm submitting a feature request to unpack these XMLs/JSONs, or at least give an option to flatten selected nodes within these sources and load them into destination.