Connector parameters for selecting database in multi-tenant environments

A setup might be something like this. Let's say there is CustomerAnalytics schema. Under that main schema there is a database for each individual customer (customer_a, customer_b, etc.). Each database has a same structure (tables, views, etc.).

Running a query let's say "select col1, col2, col3 from customer_a.table_b" would looks the same across all customers. So if I wanted to get data for customer_b that query would look like "select col1, col2, col3 from customer_b.table_b" (only customer name would change)

We can do this via Information Services but the ask is for the similar functionality to be added to data connectors (this specific one is for Amazon Redshift).

It can be done either by passing a parameter value or maybe running a pre-query statement which would be used to set the proper database. Any options would work really. Thanks.