When running Tableau against BigQuery, there is no Query History

Question

When running a report on the Tableau Cloud against BigQuery, there is no Query History. Even when I refresh the datasource with a new day of data, and I see that the report now shows the new date, there is no Query History. I need to see the History to calculate costs and to understand what Tableau is doing behind the scenes.

score 5 · Accepted Answer · answered Dec 17 '14 at 16:58

5

Make sure to use same user for tableau and for retrieving query history

answered Dec 17 '14 at 16:58

N.N.

3,094
21
41

Thanks! That's crazy that the administrator would not be able to see all of the queries. Queries have a cost and only the query history tells me who is creating what costs. The admin has to know what costs are being incurred by who! Oh well I'll complain to Google :-) – HannahS Dec 21 '14 at 10:41

score 2 · Answer 2 · answered Dec 22 '14 at 03:09

2

There is a flag administrators can use on the jobs API to retrieve jobs for all users in the project they administer. See the allUsers flag described at: https://cloud.google.com/bigquery/docs/reference/v2/jobs/list

This functionality is not available in the UI but you can use the command line tool (bq) to retrieve jobs across users. It has a flag that enables this option.

answered Dec 22 '14 at 03:09

Siddartha Naidu

86
1

Thanks. Jobs includes any queries that they run in the UI? – HannahS Dec 28 '14 at 10:14
1

Yes, each query is associated with a job. – Siddartha Naidu Mar 13 '15 at 04:51

When running Tableau against BigQuery, there is no Query History

2 Answers2