ricky_renner
03/17/2021, 1:30 PMtarget-postgres
is letting me know that it succeeded but when I check the database, I do not see any data. I'm running my target Postgres database in a Docker container as well as my Meltano pipeline, so I'm wondering if it's some networking issue. However, it's weird that it is telling me it succeeded. Has anyone seen this before?taylor
03/17/2021, 2:09 PMtarget-postgres
but my first guess would be a permissions issue on the database. Are you logging in with the user used to load the data or a separate use? Also, any logs you can share? running with meltano --log-level=debug
may be useful tooricky_renner
03/17/2021, 2:34 PMtap-spreadsheets-anywhere | INFO Wrote 22 records for stream "customer_discount".
target-postgres | time=2021-03-17 13:16:26 name=target_postgres level=INFO message=Loading 22 rows into 'excel_source_files_meltano."customer_discount"'
target-postgres | time=2021-03-17 13:16:26 name=target_postgres level=INFO message=Loading into excel_source_files_meltano."customer_discount": {"inserts": 0, "updates": 22, "size_bytes": 4014}
target-postgres (out) | {"customer_discount": {"modified_since": "2021-03-17T12:56:37.050000+00:00"}}
ricky_renner
03/17/2021, 2:44 PMricky_renner
03/17/2021, 2:55 PMversion: "3.8"
services:
bw-meltano-ui:
build: .
command: ui
depends_on:
- bw-meltano-db
- bw-meltano-target-db
env_file:
- ./config/meltano-ui.env.dev
# environment:
# - MELTANO_PROJECT_READONLY: 1
ports:
- target: 5000
published: 5000
networks:
- bw-meltano-net
volumes:
- ./meltano.yml:/project/meltano.yml
- ./extract/:/project/extract/
- ./load/:/project/load/
- ./model/:/project/model/
- ./orchestrate/:/project/orchestrate/
- ./transform/:/project/transform/
bw-meltano-target-db:
image: "postgres"
env_file:
- ./config/meltano-target-db.env.dev
networks:
bw-meltano-net:
ports:
- target: 5432
published: 5433
bw-meltano-db:
image: "postgres"
env_file:
- ./config/meltano-db.env.dev
networks:
bw-meltano-net:
ports:
- target: 5432
published: 5432
networks:
bw-meltano-net:
ricky_renner
03/17/2021, 2:56 PMdocker-compose.yml
file. So basically I'm trying to create an environment that we can test out our pipelines by just running docker-compose up
ricky_renner
03/17/2021, 2:57 PMtaylor
03/17/2021, 2:59 PMmeltano config target-postgres
return what you expect?taylor
03/17/2021, 2:59 PMricky_renner
03/17/2021, 2:59 PMdouwe_maan
03/17/2021, 3:35 PMbw-meltano-target-db
? How are you accessing it from your host machine?ricky_renner
03/17/2021, 3:36 PMlocalhost:5433
douwe_maan
03/17/2021, 3:38 PMbw-meltano-target-db
and port to 5432
? (Since internal networking should use the regular port, not the published one)ricky_renner
03/17/2021, 4:08 PMdouwe_maan
03/17/2021, 5:42 PMricky_renner
03/17/2021, 6:04 PMricky_renner
03/18/2021, 7:41 PMricky_renner
03/22/2021, 1:34 PMdouwe_maan
03/22/2021, 6:29 PMricky_renner
03/22/2021, 6:34 PMtarget-postgres
is running successfully, but when it finishes, there is still nothing in the database. I'm assuming I'm just targeting the wrong postgres database, but I'll have to go back and confirm thatdouwe_maan
03/22/2021, 6:35 PMaaronsteers
03/22/2021, 7:01 PMricky_renner
03/22/2021, 8:18 PM