1 / 34

The Tableau Repository

The Tableau Repository. Click to edit Master subtitle style. PRESENTED BY. Russell Christopher. Click to edit title. Click to edit subtitle style. Title. The Tableau Repository. Agenda. About the repository Connecting to the repository Unsupported but very interesting information.

uta
Download Presentation

The Tableau Repository

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Tableau Repository Click to edit Master subtitle style PRESENTED BY Russell Christopher

  2. Click to edit title Click to edit subtitle style

  3. Title

  4. The Tableau Repository

  5. Agenda • About the repository • Connecting to the repository • Unsupported but very interesting information

  6. What is it? PostgreSQL

  7. Where is it? Port 8060 on one or more machines

  8. How do I connect to it? • http://kb.tableausoftware.com/articles/knowledgebase/creating-custom-administrative-views Google: “Creating Custom Admin Views Tableau” to find...

  9. What can I connect to it with? • Tableau • PGAdmin3 • Other

  10. Drivers? www.tableausoftware.com/drivers

  11. The Tables • Original views (legacy) • hist_tables (new in v8)

  12. The “Tableau” user • Granted minimum permissions • Mostly can’t see underlying tables • Just not very much fun

  13. Legacy (“Original”) Views

  14. “Original” Views: What can you see? • HTTP Requests • Sessions • Users • Views • Customized Views • Data Sources Workbooks Data Sources Background Tasks Projects Sites Tags

  15. Warning! http_requests gets big!

  16. Warning! We truncate to 10 days of data upon backup or ziplogs

  17. Warning! Back this data up (extracts?) if you want > 10 days of history.

  18. Demo “Views”

  19. V8 “History” Tables

  20. A work in progress • They are “real” tables • Complete with Referential Integrity Constraints • Closely models “inaccessible” tables • Days to truncate is configurable • Implementation is not complete yet.

  21. “History” Tables: What can you see? • Historical Events • Event Types • Capabilities • Groups • Data Sources • Data Connections • Views • Users • Licensing Roles Schedules Tasks Configurations Workbooks Projects Sites Tags Comments * Red tables not yet populating with data

  22. Demo “History Tables”

  23. Contrast: Legacy Views v. History Tables Legacy Views: Examples • User interaction • Who ran report ‘x’? • When? • How long did it take? Scheduled Tasks Who ran refresh task? Did it succeed or fail? “Consumption-centric”

  24. Contrast: Legacy Views v. History Tables History Tables: Examples Schedule creation Who created a schedule? Who added a task to it? Admin Who created a new project? Who added user x to group y? Content creation Who published a workbook? Who modified it? Who changed the connect string? Who changed permissions on it? “Admin-ish”

  25. NOT supported. None of the following, repeat NONE of it is supported.

  26. Going off road

  27. NOT supported. None of the following, repeat NONE of it is supported.

  28. Supported “public” tables have gaps • “Who owns what report a?” • “I want a list of every report user x can see” • “What server is data source y connecting to?” • Tableau user is R/O

  29. Other users • Have full access to the database • Can do anything • Are risky to leverage • Are not supported • USE AT YOUR OWN RISK

  30. Example

  31. Demo • “Backdoor stuff”

More Related