Hello team, I'm trying out the meltano variant of target-snowflake and running into an issue where a JSON array is stored as a string which is not valid JSON but instead seems to be a stringified python list

[{'value1': None, 'value2': 'somestring'}]

Note the single quotes and Python's

None

. This is causing problems when attempting to use

parse_json

on the field.

At the moment we do not deconstruct nested arrays. Arrays are stored as STRINGs with the relevant JSON representation stored as is. e.g. "['banana','apple']"

I'd still expect the string to be valid JSON. wdyt, does this merit a new issue?

Interesting, please file an issue if it's not being stored as it should!

Done! https://gitlab.com/meltano/target-snowflake/-/issues/31