Hello Team, Need help debugging this ELT operation...
# plugins-general
h
Hello Team, Need help debugging this ELT operation. It shows extraction as completed but I do not see any changes/tables in the target database. Note: I'm running everything on docker: meltano, tap-mysql (MySQL DB as container), target-postgres (Postgres DB as container)
$ meltano elt tap-mysql target-postgres --job_id=mysql_to_postges_el
meltano | Running extract & load... meltano | A catalog file was found, but it will be ignored as the extractor does not advertise the
catalog
or
properties
capability target-postgres | /project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/psycopg2/__init__.py144 UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>. target-postgres | """) tap-mysql | INFO Server Parameters: version: 8.0.21, wait_timeout: 2700, innodb_lock_wait_timeout: 2700, max_allowed_packet: 67108864, interactive_timeout: 28800 tap-mysql | INFO Server SSL Parameters (blank means SSL is not active): [ssl_version: ], [ssl_cipher: ] tap-mysql | INFO No properties were selected meltano | Extract & load complete! meltano | Transformation skipped