https://linen.dev logo
#plugins-general
Title
# plugins-general
m

mykola_zavada

10/18/2023, 2:11 AM
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.
Copy code
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!