Hi,
@steven_zarka - and welcome! The Meltano team is excited to announce today our official launch of our new Meltano Hub for singer connectors, which lists over 200 possible source systems - although we are still working with the community to curate the best of the best and make the maturity of each tap more transparent.
First - can you tell if any connectors there would match to a queue system you might be considering?
Singer Taps | MeltanoHub
Second - if the connector does not yet exist, you are definitely empowered to create your own connector using our Python-based
#C01PKLU5D1R. While in theory, this is possible, the challenge with a queue-based systems (I’m thinking similar to SQS) is that the queue system generally wants to confirm receipt and processing of each message in the queue individually - which you would have to optimistically assert. Can you confirm if this is a requirement you are looking to meet in this implementation?
In theory, if you run the sync cycle in small batches, the confirmation you receive from the target, in form of the bookmark incremented in its subsequent execution, would give you a strong positive confirmation that the records were indeed written.
Update: as
@ivanovyordan notes, another option could also create a caching layer in a custom tap which provides its own independent confirmation of write (allowing the queue to receive positive per-message confirmation) and then subsequent executions could stream directly from the queue and also from the cache, in case that a bookmark is requested at a prior token than is the latest in the queue.
Hope this helps!