Supabase Foreign Key to Identity ID instead of Auth User ID

I have a foreign key between owner_id and the Supabase User ID. is there any way to have that relation to the IDP (Identity) ID itself? (in my case Keycloak)

Something like auth.identities.provider_id doesn't seem to work, getting:
ERROR: 0A000: cross-database references are not implemented: "auth.identities.provider_id"
ebe222f993019c4b354b4484eed2fdf1efddd9abe2ff0df097eadc1f842be155.png
Was this page helpful?