requesting_user_id() function to get 'sub' from Clerk JWT
I'm simply trying to pull the user ID from Clerk into Supabase as the default value for user_id.
I've made the requesting_user_id() sql funciton and placed it inside the default value for my user_id column but it remains blank. I've read the tutorials on Supabase and Clerk websites about grabbing the 'sub' from the Clerk token but i'm having no luck. Any suggestions? Thanks!
I've made the requesting_user_id() sql funciton and placed it inside the default value for my user_id column but it remains blank. I've read the tutorials on Supabase and Clerk websites about grabbing the 'sub' from the Clerk token but i'm having no luck. Any suggestions? Thanks!
