andrew_stewart
03/31/2021, 7:48 AMtap-mongodb
to target-postgres
pipe:
target_postgres.exceptions.SingerStreamError: ('Invalid records detected above threshold: 0. See `.args` for details.'
I believe this my be an instance of this issue: https://github.com/datamill-co/target-postgres/issues/114 - where target-postgres doesn’t support anyOf
types?
Curious for any approaches to follow here. I imagine that has something to do with trying to extract varying nested structures from mongo into postgres, and therefore more explicit meltano select
logic may be in order?juan_sebastian_suarez_valencia
03/31/2021, 7:51 AMandrew_stewart
03/31/2021, 7:56 AMjuan_sebastian_suarez_valencia
03/31/2021, 7:58 AMandrew_stewart
03/31/2021, 8:10 AMtarget-jsonl
output and narrowed my tap-mongodb
select to just a few fields… and still the same exact error; and looking through the logs while playing around, it looks like it always keeps selecting everything no matter what I do.
This seems to correspond with the issue i linked to above. Hrmmmmm.douwe_maan
03/31/2021, 5:05 PMandrew_stewart
03/31/2021, 6:26 PMtarget-jsonl
. I imagine bigquery / snowflake type targets might naturally handle nested structured fields in some graceful way (maybe?)andrew_stewart
03/31/2021, 6:34 PMtarget-jsonl | jsonschema.exceptions.ValidationError: [{ ... }, { ... }, ... { ... }, }] is not valid under any of the given schemas
target-postgres | target_postgres.exceptions.SingerStreamError: ('Invalid records detected above threshold: 0. See `.args` for details.', [(<ValidationError: '[{ ... }, { ... }, ... { ... }, }]'
douwe_maan
03/31/2021, 7:57 PMandrew_stewart
03/31/2021, 8:14 PMdouwe_maan
03/31/2021, 8:16 PMmeltano --log-level=debug elt
, you should see the specific SCHEMA and RECORD messages printed that result in the error. That should help us verify where the discrepancy originatesandrew_stewart
03/31/2021, 9:22 PMmeltano select
to project into just a few very specific fields, and yet the tap seems to just pull everything anyway. So there might be an issue there.andrew_stewart
03/31/2021, 9:29 PMandrew_stewart
03/31/2021, 9:29 PMtarget_postgres.exceptions.SingerStreamError: ('Invalid records detected above threshold: 0. See `.args` for details.', [(<ValidationError: '[{\'foo\': \'bar\', \'key\': \'value\', ...
douwe_maan
04/01/2021, 4:02 PMtap-mongodb (out)
like for that RECORD
message? It should have been written just before that error (and its stacktrace)andrew_stewart
04/01/2021, 5:51 PMdouwe_maan
04/01/2021, 5:51 PMandrew_stewart
04/01/2021, 6:52 PMdouwe_maan
04/01/2021, 8:40 PM.meltano/logs
andrew_stewart
04/01/2021, 9:12 PMandrew_stewart
04/01/2021, 10:34 PMandrew_stewart
04/01/2021, 10:34 PMandrew_stewart
04/01/2021, 10:35 PMtarget-mongodb
to treat certain fields as json/strings ?douwe_maan
04/01/2021, 10:36 PMandrew_stewart
04/01/2021, 10:36 PMandrew_stewart
04/01/2021, 11:21 PMandrew_stewart
04/01/2021, 11:21 PMandrew_stewart
04/02/2021, 1:09 AM