Load XML file to variant data type column in Snowflake
Hi ! I am trying to load contents of a complete XML file to variant column in Snowflake. tFileInputXML component seem to read rows from the fields in XML. Please advise what components and design approach can i use to load complete XML to variant column of a table in snowflake?
I'm trying to load data from SQL server to snowflake table with variant data type. The data type of said columnin sql server is varchar(max) containing xml data. I'm unable to load it into the snowflake table with Variant data type. However it does work when the snowflake table column is varchar data type. any ideas how to fix this?
