CODEWITHSUNDEEP
google-bigquerytableau-api
HannahS
HannahS

Reputation: 803

When running Tableau against BigQuery, there is no Query History

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.

Upvotes: 3

Views: 308

Answers (2)

Siddartha Naidu
Siddartha Naidu

Reputation: 86

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.

Upvotes: 2

N.N.
N.N.

Reputation: 3172

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

Upvotes: 5

Related Questions