Reference to auth.users?
i was following ben davis video about sveltekit + supabase/drizzle. in his video he mention that he want to use sql file in supabase/migrations as a source of truth and then rewrote it in schema.ts,
but i prefer to use schema.ts as a source of truth then use the drizzle migrations.
the problem is that i can't reference the auth.users like in the .sql file
5 Replies
yea currently there is no official support from supabase to get
auth.users
might check this issue on githubGitHub
Add ability to (read-only) query the auth.users table directly with...
Feature request I suggest adding the ability to query (read-only) the auth.users table directly with a service key. Many production apps need this ability... Describe the solution you'd like //...
any news on this?
any work around or whats the current way of working with supabase auth with drizzle orm? sorry newbie here also running into the exact same problem
I just manually added the foreign key from public.profile id -> auth.users id and followed this https://supabase.com/docs/guides/auth/managing-user-data#using-triggers