if anyone familiar with the target-postgres plugin...
# plugins-general
e
if anyone familiar with the target-postgres plugin has seen or knows about
KeyError(columnName)
I'd love to hear how I get past this.. I am under the impression perhaps to get unblocked I must setup the table I am loading to myself? https://github.com/datamill-co/target-postgres/issues/206 Edit: thinking next I might switch to different variants of the target like https://github.com/transferwise/pipelinewise-target-postgres
e
I haven't used these taps/targets myself, but you shouldn't need to create any target tables or columns. Just reading what you wrote, I'd want to verify that you mean for there to be 5 primary keys columns defined and that they all actually exist in the csv. The docs point out that
keys
are "the names of the columns that constitute the unique keys for that entity", not the list of column names, which I suspect is how you are using it?
e
ah hah.. okay.. so I need to pick a PK and those are the "keys" to wire in to the config.. I may retry by backing off then ! great help @edward_smith thanks