topic Re: Data loading to snowflake using tsnowflakeoutput in Talend Studio

Data loading to snowflake using tsnowflakeoutput

Fzamk19 — Fri, 15 Nov 2024 22:14:49 GMT

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

Re: Data loading to snowflake using tsnowflakeoutput

Anonymous — Mon, 26 Dec 2022 07:42:30 GMT

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

Re: Data loading to snowflake using tsnowflakeoutput

Fzamk19 — Mon, 26 Dec 2022 08:54:36 GMT

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