Supabase Schemas won’t work other than public in n8n.
I tried to access other schemas in supabase other than default public schema, however I can’t seem to fetch any of the tables from schemas other than public. There was an option called, custom schema and I enabled it, inserted the schema name but it says error fetching supabase options.
I tried to configure from supabase. Did all kinds of codes but nothing really.
create schema if not exists document;
grant usage
on schema document
to postgres, anon, authenticated, service_role, dashboard_user;
alter default privileges in schema document
grant select, insert, update, delete
on tables
to postgres, anon, authenticated, service_role, dashboard_user;
grant select, insert, update, delete
on all tables in schema document
to postgres, anon, authenticated, service_role, dashboard_user;
grant usage, select
on all sequences in schema document
to postgres, anon, authenticated, service_role, dashboard_user;
Information on your n8n setup
- n8n version: 2.6.3
- Operating system: Windows 11
