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.