Can't select Auth Tenant when listing users in Firebase Auth (Self Hosted)

Self-Hosted Retool version 3.114.3
We are using Retool to query data in our Firestore DB and now also want to query Firestore Auth users as well.

Creating a query using a Firestore Connection, GUI Mode,
Service type: Firebase Auth (user management), Action type: List users
works, but only returns users in the main (production) environment.

I want to be able to list users in our Auth Tenants as well.
In regular (not self hosted) Retool, I can create a query in Raw Mode and
get the auth object for the tenant and use this to list the users (and it works):
const auth = db.auth();
const tenantManager = auth.tenantManager();
const tenantAuth = tenantManager.authForTenant('tenant_id_here');
const selectedAuth = (select5.value === 'prod') ? auth : tenantAuth;
...
selectedAuth.listUsers() etc

However, self-hosted retool doesn't allow queries in Raw Mode and returns the message "Error with sandbox evaluation"

I read somewhere in the forums that Firebase queries in Raw Mode were unavailable for Self-Hosted Retool and it is on the back burner. Is that still the case, or is it likely to be implemented soon?

How else am I to access Firebase Auth Users in a Tenant?

Thank you

:wave: Hi @serena,

Sounds like you're working towards a solution here :slightly_smiling_face: