Snowflake Bulk exec - strip outer array

NNot_defined1646723267 — Fri, 15 Nov 2024 23:02:12 GMT

Hi,

I am trying to get api response that has structure like

{ "metadata":{},

"values": [

"transaction1":{"key1":"value1"},

"transaction2":{"key2":"value2"}

]}

I wanted to load only values part into snowflake. It is very huge json response. So I want to split each value from json response to one row in snowflake using

STRIP_OUTER_ARRAY=TRUE

trest -> textractJSON field -> tsnowflakebulkexec

in textractjsonfield, i m reading values part and sending it to next component. The file that is put in snowflake has below format "[""transaction1"":{""key1"":""value1""}, ""transaction2"":{""key2"":""value2""}]"" and so i m not able to use STRIP_OUTER_ARRAY=TRUE in custom copy command in snowflake bulkoutputexec.

Enclosing array in " and escaping every " with " is happening internally. Is there something I can do to make it work? Any suggestion are welcome

Thanks in advance

Using Talend 7.3

Re: Snowflake Bulk exec - strip outer array

Jai1 — Thu, 19 Oct 2023 19:31:24 GMT

Hi ,

Did you find answer to this question ?

topic Snowflake Bulk exec - strip outer array in Talend Studio

Snowflake Bulk exec - strip outer array

Re: Snowflake Bulk exec - strip outer array