BigQuery - SESSION_USER() do not display the current user email ( Google data Studio)

This is SQL view which I'm using ( Standard SQL)

SELECT
SESSION_USER() AS USER


As well I have tested Legacy one

SELECT
CURRENT_USER() AS USER


In both circumstances, it displays my name when I run view through Data Studio, any suggestions that it will display email based on who opens this Data Studio report?

1 Answer
1

I think if your connection to the data-set uses you credentials then it will bring back your email.

If you change the report data-set in data studio from owner credential to viewer credential it should bring the email of the person viewing the report. However, they will need to have access to the data-set to see any data.

Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.