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
