Access data from Supabase non-public Schema

We have an existing database that has a lot of data in a non-public Schema. I can’t seem to figure out how to access any of that data, I can only see the Public schema. Can anyone help. Alternately, is there source code for the Supabase Plugin where I could just tweak a few lines?

Hey there,

Did you try to create a View in SupaBase ?
I think it can access any Schema (at least I did it for Users), and you should get it okay in WeWeb then.
The only thing I didn’t crack just yet is how to secure a view. It’s not the same as for a Table with RLS / Policies.

Have a nice day.

Matth

Yeah, we are highly reliant on RLS, so that approach doesn’t quite work.