Hi. I am hoping you have already had a similar cas...
# support-questions-legacyb
bteres
04/08/2024, 6:32 AMHi. I am hoping you have already had a similar case to this and can advise. We have userId in most of our data so that we know who performed the action. We are creating reports with BigQuery and would like to join that field to Supertokens to get the user primaryEmail. Is there a simple way to do this?
r
rp_st
04/08/2024, 6:56 AMhey @bteres are you self hosting supertokens?
b
bteres
04/08/2024, 7:05 AMYes.
r
rp_st
04/08/2024, 7:39 AMright. So i think we have tables in which we store the user's email mapped to their user ID. You can pick it up from thjat
b
bteres
04/08/2024, 7:44 AMOK. So we just link directly to the PostGres instance?
r
rp_st
04/08/2024, 7:44 AMyea. that would be the best way
b
bteres
04/08/2024, 8:16 AMOK. Will see what we can do. Thanks. Do you have the table name we should use?
r
rp_st
04/08/2024, 8:54 AMemailpassword_users / thirdparty_users / passwordless_users
rp_st
04/08/2024, 8:54 AMdepending on which login method you use
b
bteres
04/08/2024, 10:26 AMCool. Thanks.
bteres
04/08/2024, 10:48 AMI made a mistake. We are not using the self=hosted option.
r
rp_st
04/08/2024, 11:01 AMah right
rp_st
04/08/2024, 11:01 AMthen, well, you don't have access to the prod db directly
rp_st
04/08/2024, 11:01 AMso instead, i would recommend you store a mapping of user id -> email in your own db and then use that
rp_st
04/08/2024, 11:02 AMor, im not sure if bigquery allows you to query any source. Then you can use our core's api to get the user object from the user id and extract the email from that too
b
bteres
04/08/2024, 2:24 PMOK. That is what I thought. Thanks.