I have same scenario but I'm not able to find any example for this implementation.

Left a reply here: https://meltano.slack.com/archives/C01PKLU5D1R/p1687532720620889?thread_ts=1666438677.664119&cid=C01PKLU5D1R