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.