Good evening everyone. I'm trying to stream data ...
# plugins-general
t
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.
Copy code
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.