Hello everyone! We're in the process of setting up...
# troubleshooting
j
Hello everyone! We're in the process of setting up Facebook targets for Meltano, and are running into this error with pipelinewise-target-redshift:
Copy code
2022-03-08T02:38:34.557484Z [error ] Loading failed code=1 job_id=tap-facebook message=target_postgres.exceptions.PostgresError: ('Exception writing records', PostgresError('Unsupported type `numeric` in existing target table')) name=meltano run_id=4046e850-eca1-43aa-81d7-374532b59d88
The thing is, we're pointing the target at an empty schema, so any datatypes in the tables are being written by the target itself. Any ideas?