Data loading to snowflake using tsnowflakeoutput

[Fzamk19]

I have a table at snowflake which has all the columns as variant data type. When I load the data into the table using tsnowflakeoutput component.

The error I receive is Error Parsing json.

But when I add double quotes(tmap) around my data then data is loaded successfully and then on snowflake table all the data is shown in double quotes which is not the requirement.

Can anyone tell me what am I doing wrong?

Note: Input data is coming from an api in json format which is being extracted using textractjsonfields and then loaded into snowflake

[Anonymous]

Hi

It seems we can't load data to snowflake variant field using tSnowflakeOutput, the component doesn't support variant type. To insert a variant data, you can use tSnowflakeRow component, see

or build the json string from input data,

 

for inserting a XML data into variant field, please refer to this page.

In your case, why don't you load the whole json string returned by API into one variant column?

Regards

Shong

[Fzamk19]

Thanks @[shong]​ .. Let me test this out