how do you configure what data associated with the user from the db is returned i the user_metadata object when a session is returned after loggin in?

That object is just the content of users.raw_user_meta_data column in auth schema

well i don't want to shove duplicate data in there. is there a way to pull other data in?

By updating that table with SQL client on the server-site is a possible way of doing it, but I would not recommend it and rather go with a custom table (like profiles) in the regular public schema.

right i have a table called projects with a id. i would like to returned the ids of the projects associated with the user in the metadata object

I would recommend making an extra request which returns that relation. I expect that you have some table like public.project_members or something like that

it's going to be such a frequent request made through out the app i was hoping to not have to make the same request on every trip

Or create a custom Postgres function which will return users projects with RPC call

hmm

Can you cache that result? I am for example using a react-query as a wrapper that holds the data in the cache

server side?

No, on the client site. I don't think that the repetitive calling will be that big of a deal as you might think 🙂

just trying to get ride of repetitive waste