Multi Tenancy support on Redash

Our scenario is that we have a tenancy model including multiple tenants using the same postgres database, only discriminated by a table-level tenant id.

So, Is there a possibility to intercept the queries that Redash fires in order to append a tenant id to the where clause by tweaking the celery threads within?
Will there be any caching issues?

or do we need to use different schema’s per each tenant?

Any advice on potential techniques or alternate approaches here? Thanks in advance for any help.

Redash doesn’t support multi-tenancy like this. There are some features built-in for our use operating app.redash.io but it’s never been supported for the community users :frowning: