Hello everyone I'm using

tap-postgres

by

meltanolabs

and I have a column in the postgres table that contains strings like this

{text_sent}

and it's automatically converts into array

['text_sent']

and when I put it into snowflake the target column is VARIANT.

When I added to the tap
config:
      stream_maps:
        public-table_name:
          actions: str(record['actions'])

it delivered a string

['text_sent']

into Snowflake. I can add

.replace("['", "{").replace("']", "}")

to convert it back to

{text_sent}

but I hope that it's possible to disable the initial transformation in an array. I would really appreciate if you help me to disable it. Thank you!