Hi, I am trying to use the tap-postgres <https://...
# meltano-plugin-development
f
Hi, I am trying to use the tap-postgres https://hub.meltano.com/extractors/tap-postgres/() 1. I have set up the config in this fashion with the correct username, password, etc (as shown below): - name: tap-postgres variant: meltanolabs pip_url: git+https://github.com/MeltanoLabs/tap-postgres.git config: sqlalchemy_url: "postgresql://[username]:[password]@localhost:5432/[db_name]" 2. I have proven that for this sqlalchemy_url I can connect to the dB in question, and load the data via the sqlalchemy 'create_engine' object. 3. However when I test the tap in Meltano, I'm getting the following error: "info ] The default environment 'dev' will be ignored for
meltano config
. To configure a specific environment, please use the option
--environment=<environment name>
. Need help fixing this problem? Visit http://melta.no/ for troubleshooting steps, or to join our friendly Slack community. Plugin configuration is invalid (Background on this error at: https://sqlalche.me/e/20/f405) " Could you advise please? Thank you so much for your time Fred
e
Hi @Frederic! Can you try adding https://docs.meltano.com/concepts/plugins/#select-extra to your plugin?
f
Thank you for your response. However, I am failing to see how this will help.
e
meltano config ... test
will fail if the extractor does not emit any
RECORD
messages, which is the case for database extractors where no streams are selected by default, so you need to explicitly select them with the above setting.
f
Oh I see… thank you. I will try that.
🙏 1