Good evening everyone. I'm trying to stream data from

tap-quickbooks

into

target-postgres

The strange thing is that the table was created with Capitalized name while the target insisted on lower case.

2023-04-03T02:08:35.748932Z [info     ] sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "quickbooks.account" does not exist cmd_type=loader name=target-postgres
 run_id=4fa50149-e39e-4450-8752-b2a4a3b27b5a state_id=2023-04-03T020821--tap-quickbooks--target-postgres stdio=stderr
2023-04-03T02:08:35.749057Z [info     ] LINE 1: UPDATE quickbooks.Account cmd_type=loader name=target-postgres run_id=4fa50149-e39e-4450-8752-b2a4a3b27b5a state_id=2023-04-03T020821--tap-quickbooks--target-postgres stdio=stderr
2023-04-03T02:08:35.749214Z [info     ]                ^               cmd_type=loader name=target-postgres run_id=4fa50149-e39e-4450-8752-b2a4a3b27b5a state_id=2023-04-03T020821--tap-quickbooks--target-postgres stdio=stderr

1. Do note that the table

quickbooks.Account

is indeed created in my postgres db. 2. Note the Undefined Table relation is all lowercase 3. The Update function uses the Capitalized table name.

@terry_lee hmm this is strange. Did target-postgres create the table originally or was the table already existing in postgres?

@pat_nadolny yes, the ML variant. I'll try with the TF variant. PS. I'll keep an eye on the GH issue. Thank you!