Source MySQL: different schemas with same prefix and same tables

[carlonuccio]

Tell us about the problem you're trying to solve

We've more than 1k schemas with same prefix and same tables on a MySQL instance. So now, we need to declare each source airbyte connection for each schema. Example:

| prefix_schema1
| --- table1
| --- table2
| prefix_schema2
| --- table1
| --- table2

Describe the solution you’d like

It could be useful to have a unique source definition to query all schemas.

Describe the alternative you’ve considered or used

I'm considering to use rest api to create dynamic source connections

Additional context

Are you willing to submit a PR?

Yes

[YowanR]

Awesome @carlonuccio! We're excited to review your PR as soon as it's ready :)