Hi SP Hsu,
I am sailing in same boat! I have a similar requirement where I would need to parse the Tableau log files to extract the information. Information pertaining to what filter actions are most frequently used by end-users. Could you enlighten me on your approach to parse the log files?
Thank you in advance!
I don’t have any good idea to solve the logs parsing up to now. If I have any good news for this question, I will share to you. Thank you.
Please share if anyone finds anything. We are looking for same to track user activity at content level.
This is not a perfect answer but maybe this will help somehow?
When a user clicks on Export > Data, in the postgres the _http_requests table's "Action" column will have "viewData". As for Export > Image or Export > PDF, the same column will have "tempfile". Example:
Hope this will help you further parse the logs.
Dear Vien, thank you.
This is maybe not a perfect answer but looks like useful for us.
But, how do I have the permission to read the table “http_requests” in the postgres DB ? < Query Failed. 7: ERROR: permission denied for relation http_requests; >
I have only the permission to read the hist_xxxx tables. (like: hist_configs, hist_workbooks, ……)
Which account or role could have this permission to read all tables in postgres DB?
Thank you Vien. I too agree with SP HSu, how do we access tables other than hist* and _* ?
Actually with the release of Tableau Server 8.2.1, all of the tables in the database is accessible (read-only) with the "tableau" user. This is just a "mini-feature" for version 8.2.1 and the official release for the feature will come probably in the next release.