Hi, I'm just starting with Meltano and I mostly like it. I started a simple flow and wanted to extract data from google sheets. its documentation, taken from singer, describes more or less how to manually get the keys with the google api cosole and a manual oauth flow execution with browser and curl. Now I see that Meltano provide it's own oauth service endpoint. Can it be leveraged for this purpose?

Hi Raphael. Meltano UI did have an OAuth endpoint, the webpage says it's for development use and the team paused UI development for awhile so don't know whether they still want to support that: https://meltano.com/docs/settings.html#oauth-service-url The general idea is sound though. We had a requirement to allow users to easily give OAuth consent for our service to pull their data in their own meltano project, without giving away our client id and secret that was used for the consent. Do do that, the taps can request a proxy oauth url (proxy because the oauth request is made with a JWT to our endpoint, then our client id and secret added when requesting google): https://github.com/Matatika/tap-google-analytics/commit/f64a5a351040189afc32e2b59dee1919b285ad5d We recently proposed a MR to make this part of the SDK: https://gitlab.com/meltano/sdk/-/issues/270

Cool, thanks, I'll have a look. I guess it makes sense to make it part of SDK. since signal plugins are just executables, nothing should stand in their way to start some lightweight http server to accept the redirect, and it probably makes sense to make it a part of the SDK. Cheers