Repository queries and Admin Insights dashboards
Build custom administrative views on the Tableau Server repository (access, retention, historical event tables, safe connection practice) and long-lived Admin Insights dashboards on Tableau Cloud (project rules, Starter updates, data source fields and joins).
3.1 Create custom administrative views: 3.1.1 Interpret the repository schema and the event types; 3.1.2 Build admin dashboards for common scenarios; 3.1.3 Utilize Admin Insights on Tableau Cloud.
~8 min read · 21 practice questions
What the exam expects
- Enable and connect to the Tableau Server repository safely, and keep custom views working through restarts and repository failover.
- Interpret the repository schema: historical event types and action types,
hist_*tables, actor and target references, retention per table. - Build admin dashboards for common scenarios (deletions audit, view traffic, job queue wait, inactive users, login-based licence use).
- Use Admin Insights on Tableau Cloud: project and Starter workbook rules, sharing, data source choice, fields, joins and data history limits.
Key terms: repository (the workgroup PostgreSQL database that stores Tableau Server data); custom administrative view (a workbook you build on repository data); Data Dictionary (Tableau's As-Is reference to repository tables); Admin Insights (a Tableau Cloud-only project of curated data sources plus the Admin Insights Starter workbook); Tableau System Account (owner and updater of Admin Insights content).
Key facts
- Detail
tsm data-access repository-access enable; restarts Tableau Server
- Detail
- PostgreSQL, port 8060, database
workgroup, repository node name
- Detail
- Unsupported; can break Tableau Server
- Detail
pgsql.preferred_host, case-sensitive, as intsm status -v
hist_ retention- Detail
wgserver.audit_history_expiration_days, default 183
_background_tasks- Detail
- Cleaned automatically; last 30 days
- Detail
- Temporary workbook generated by a built-in admin view
- Detail
- As-Is; community forums
- Detail
- 90 days default, 365 with Advanced Management
- Detail
- Updates stop; delete it, new project next day
- Detail
- Gone within 36 hours; Unlicensed users stay
- Detail
- Add Site LUID = Site LUID
Sources for this section (7)
- Collect repository datahelp.tableau.com (opens in a new tab)
- Tableau Server Repositoryhelp.tableau.com (opens in a new tab)
- Custom admin viewshelp.tableau.com (opens in a new tab)
- Data Dictionaryhelp.tableau.com (opens in a new tab)
- Manage Admin Insightshelp.tableau.com (opens in a new tab)
- TS Usershelp.tableau.com (opens in a new tab)
- TS Eventshelp.tableau.com (opens in a new tab)
- Why can a TS Events row have an empty Item Type?
- When is Job Queued Duration NULL in Job Performance?
- When Tableau replaced the Admin Insights Starter before you moved or renamed it, how can you get your version back?
- How can you find which PostgreSQL version the repository runs?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Tableau Architect pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 18 lessons of the Tableau Architect guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Practice exams purchase adds inline bank questions and topic practice (21 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Choose guide-only, practice-only, or save $4 with both