Hey! I have this query: ``` id, ...
# help
h
Hey! I have this query:
Copy code
id,
            chat_id,
            members (
              id,
              nickname,
              auth.users (
                raw_user_meta_data
              )
            ),
            created_at,
            edited_at
but get a 400 back with
Copy code
json
{
   "hint":"If a new foreign key between these entities was created in the database, try reloading the schema cache.",
   "message":"Could not find a relationship between members and auth in the schema cache"
}
Even though i do have a forign key between members and auth.users
s
You cannot query auth.users from the client library, that table is in a schema not exposed to the public, you should create a table that has the data you require from that table in the public schema
h
Oh, ok. I reccon it should be removed from the foreign key options then :)