Does anyone know of an easy way to load data into ...
# random
w
Does anyone know of an easy way to load data into snowflake but load all columns into a json blob in 1 snowflake column? I figure I could get this to work with a mapper - but thought maybe there was an easier way
I was able to accomplish with a mapper
Copy code
plugins:
  mappers:
  - name: meltano-map-transformer--just_json
    inherit_from: meltano-map-transformer
    mappings:
    - name: just_json
      config:
        stream_maps:
          [stream_name]:
            json_sheet_data: record
👍 1
still interested if there is a way to turn off parsing to columns on any of the destinations (like snowflake) - but this should work fine for what I need
I see it has a nice feature to just have everything in 1 variant column in snowflake and figure out data types and parsing later
💪 1
p
w
👍