Can passwordless and database connections share the same pool of users?


I have an existing custom database with thousands of users and want to enable passwordless email authentication. Is there a way to have it so that the passwordless connection uses the existing pool of users from the database connection? I rely on custom metadata to set specific values in my application and it’s all stored in the custom db connection.

I’ve read about using account linking but I’m concerned that my users won’t understand the concept (as it’s not an IT-related site) and will be unable to access their data. I’ve already enabled passwordless on my test tenant and when I logged in, it created a new user with the same email address as the database user.

Alternatively, is there a way to do the linking automatically? I feel presenting the user with a warning saying they already have an account will be confusing.