Qlik Talend Studio: Writing an XML file as a value into a Variant type column in a Snowflake table in a Studio Job

[TalendSolutionExpert]

This article shows how to write an XML file as a value into a Variant type column of a Snowflake table. An example of the Job is available in the sample job.zip file attached in this KB.

1. Create a table with a Variant type column in the Snowflake database using the following command:

   CREATE TABLE TEST1006
       (COL_HEADER VARIANT);

2. In Studio, use the PreparedStatement feature of the tSnowflakeRow component to read the input data as a String, and write it to the Snowflake Variant type column.

   

   
    

3. Configure the tFileInputDelimited component to read the XML file.

   

   

    

   The tFileInputDelimited schema looks like this:

   

   
    

4. Configure the tSnowflakeRow component to load the data into the Snowflake table.

   

    

   1. Enter the following command in the Query text box:

      "INSERT INTO TEST1006 SELECT PARSE_XML(?);"

   2. Under Advanced settings, select the Use PreparedStatement check box. Input values for the Parameter Index, Parameter Type, and Parameter Value.

      For more information, see the tSnowflakeRow Standard properties documentation available in Talend Help Center.

      

       

      The tDBRow schema looks like this:

      

      
       

5. Run the Job, and review the output data in Snowflake.