Just a quick heads-up for everyone trying to load data from

tap-googleads (matatika)

into

target-postgres (tranferwise)

and receiving a

psycopg2.errors.UndefinedColumn

error. Make sure to set the

data_flattenin_max_level

config setting for

target-postgres

to a high enough level. Took me a couple of hours to figure that out 😅

loaders:
  - name: target-postgres
    variant: transferwise
    pip_url: pipelinewise-target-postgres
    config:
      data_flattening_max_level: 10

Thanks for sharing @janick_otten!

Thanks @janick_otten