target-postgres; psycopg2.ProgrammingError Hi, I...
# troubleshooting
k
target-postgres; psycopg2.ProgrammingError Hi, I’m trying to extract data from csv and load it into Postgres. Since yesterday I’m getting a new error. Is this pointing to issues with psycopg2?
Copy code
eltano                   | elt       | Loading failed (1): target_postgres.postgres.PostgresError: ('Exception writing records', ProgrammingError('schema "tap_spreadsheets_anywhere" does not exist\nLINE 1: CREATE TABLE "tap_spreadsheets_anywhere"."target_user" ();\n                     ^\n',))
v
No, nothing to do with
psycopg2
"tap_spreadsheets_anywhere" does not exist
that schema needs to be created for the target varient you're using. I tend to use the transferwise variant which creates it for you.
k
thanks.