ivanovyordan
08/31/2020, 12:23 PMpaul_blankley
08/31/2020, 1:13 PMmeltano config tap-s3-json list
to see if meltano is finding your credentials properly?ivanovyordan
08/31/2020, 1:25 PMdouwe_maan
09/01/2020, 2:54 PMstdin
to close, and the tap stdout
-> target stdin
pipe to break.
Could anything be causing target-snowflake
to fail?ivanovyordan
09/01/2020, 2:56 PMloader-jsonl
and it was working.douwe_maan
09/01/2020, 2:59 PMtarget-snowflake
is not liking the JSON formatted string as much. Have you tried dumping the meltano invoke tap
output into a file, and piping it directly into meltano invoke target
, so that we can see if it's indeed failing?
You can also enable debug mode on meltano elt
to see the specific messages being sent from the tap and the target, to get an idea of what the offending record might be: https://meltano.com/docs/command-line-interface.html#debuggingivanovyordan
09/01/2020, 3:00 PMivanovyordan
09/02/2020, 3:34 PM{"type": "SCHEMA", "stream": "my-record", "schema": {"properties": {"namespace": {"type": "string"}, "object_key": {"type": "string"}, "source_system": {"type": "string"}, "timestamp": {"type": "string"}, "_file": {"type": "string"}, "_line": {"type": "integer"}}, "selected": true}, "key_properties": ["_file", "_line"]}
{"type": "RECORD", "stream": "my-record", "record": {"namespace": "my-record/bulk_sent", "object_key": "", "source_system": "main-app", "timestamp": "2020-04-28T07:45:21+00:00", "_file": "my-record/2020/04/28/07/my-record-1-2020-04-28-07-45-21-07ecc118-e76e-4456-b65d-10bd82148507", "_line": 1}}
{"type": "STATE", "value": {"my-record": "my-record/2020/04/28/07/my-record-1-2020-04-28-07-45-21-07ecc118-e76e-4456-b65d-10bd82148507"}}
douwe_maan
09/02/2020, 3:38 PMBrokenPipe
, indicating that the pipe was actually broken and the target had already quit before the tap attempted to write that schema.
Did you try running the target separately, piping in the tap output?
meltano invoke tap-s3-json > singer.jsonl
cat singer.jsonl | meltano invoke target-snowflake
That should show us whether the target fails unexpectedly.ivanovyordan
09/02/2020, 4:04 PMdouwe_maan
09/02/2020, 4:23 PMtarget-snowflake
further, but it may be more productive to see if you have better luck with https://github.com/transferwise/pipelinewise-target-snowflake or https://github.com/datamill-co/target-snowflake, either of which you can add as a custom plugin: https://meltano.com/docs/command-line-interface.html#how-to-use-custom-plugins. Have you considered using either?ivanovyordan
09/02/2020, 4:26 PMtarget-snowflake
, I'll try to fix it and open a merge request.douwe_maan
09/02/2020, 4:31 PM<http://logger.info|logger.info>
statements to your target-snowflake source at .meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_snowflake
so that it won't fail silently anymore.ivanovyordan
09/02/2020, 4:32 PMivanovyordan
09/03/2020, 9:42 AMtarget-snowflake
from Gitlab. It looks like the problem comes from snowflake-connector-python
. The version you depend on is a bit old and have troubles with Python 3.7.7.
I could spend some time in upgrading dependencies, but I don't know if that fits in your vision for the project. 🙂douwe_maan
09/03/2020, 4:02 PMivanovyordan
09/03/2020, 4:30 PMdouwe_maan
09/03/2020, 4:32 PMMatt Menzenski
12/06/2022, 3:50 PMtap-s3-json
mentioned in this thread a public tap? I don’t see it in the Meltano hub, pypi, github, or gitlab. I’m in need of the same kind of tap so would love to avoid re-implementing it if there’s a public version out there.taylor
12/06/2022, 4:03 PMMatt Menzenski
12/06/2022, 4:04 PMpat_nadolny
12/06/2022, 4:14 PMtaylor
12/06/2022, 4:15 PMpat_nadolny
12/06/2022, 4:18 PM