how can we identify big query queries ran using Tableau in big query information schema

Question

Is there a way to identify queries ran where using Tableau in table INFORMATION_SCHEMA.JOBS_BY_PROJECT in GCP Big Query

user_11063935 · Answer

If you look at the query column in INFORMATION_SCHEMA.JOBS_BY_PROJECT you'll see

SELECT'Custom SQL Query'
...

This is a way I've just discovered to ID Tableau running the query. Not concrete, but may give an indication/starting point.

Another way would be to use a service account to run the queries from Tableau and then pick it up from the user_email column.