Meltano

Hi guys, I want to establish Meltano POC solution instead of our AirByte ingestion. We have several tables from Google sheets for example, all of them with the same credentials but they create different source tables in BigQuery. How do I recreate the same extractor type but in different sheet and apply it to the meltano.yml?

There's a number of ways to accomplish this and it all depends on how many times you need a different sheet. I'd start with `inherit_from`  <https://docs.meltano.com/concepts/project#inheriting-plugin-definitions>

And then if you do it more than 3-5 times then I'd go to something with passing the data via env vars see <https://docs.meltano.com/guide/configuration/#configuring-settings>

`inherit_from` is just easier to maintain and nicer to see what's going in inside of your `meltano.yml` instead of passing the work to your orchestrator so I'd highly recommend it

It's also not a terrible idea to do 100 of these in your `meltano.yml` :shrug:  all depends on what you're after and why

Hi <@U07L4JSRRB9> which google sheets variant are you using if you’ve got that far?

I’m guessing you want the same config in all respects except the sheet name?