Establish Governance and Support Published Content16% of the exam
Admin Insights, admin views and repository data sources
Choose between built-in admin views, the Admin Insights data sources on Tableau Cloud and the Tableau Server repository, enable and query the repository with the right built-in user, and control how much history each source keeps.
Recommend the appropriate administrative views and data sources for a given scenario.
~8 min read · 7 practice questions ·
What the exam expects
- Recommend a built-in admin view, an Admin Insights data source or the Tableau Server repository, given the platform and the question to answer.
- Match a Tableau Cloud monitoring question to the Admin Insights data source or Starter dashboard that holds its data.
- Enable repository access on Tableau Server, connect from Tableau Desktop, and choose between the tableau and readonly users.
- Control how much event history the repository keeps, and what that costs.
- Find data quality warning history in an admin view and in the repository.
Key terms:
- Admin Insights: a Tableau Cloud-only project of curated data sources and the Admin Insights Starter workbook.
- Repository: the PostgreSQL database (workgroup) where Tableau Server stores user interactions, extract refreshes and more.
- Custom administrative view: a view you build yourself from repository or Admin Insights data.
- hist_ tables: repository tables holding historical events, kept for a configurable number of days.
Key facts
Admin Insights platform
- Detail
- Tableau Cloud-only project
Admin Insights refresh
- Detail
- Daily or weekly, set in Settings, General
Moved Admin Insights project
- Detail
- Updates stop; delete it and a new one appears the next day
Removed user in TS Users
- Detail
- Gone within 36 hours; unlicensed users stay
Repository type
- Detail
- PostgreSQL database named workgroup
Enabling access
- Detail
- tsm data-access repository-access enable, restarts Tableau Server
Modifying the repository
- Detail
- Can break Server; installation becomes unsupportable
auditing.enabled
- Detail
- On by default; history grows the .tsbak
hist_ retention
- Detail
- wgserver.audit_history_expiration_days, default 183
_background_tasks retention
- Detail
- Last 30 days, cleaned automatically
Data Quality Warning History
- Detail
- Needs Tableau Catalog; on Site Status
Sources for this section (6)
- Use Admin Insights to Create Custom Viewshelp.tableau.com (opens in a new tab)
- Manage Admin Insightshelp.tableau.com (opens in a new tab)
- TS Users Data Sourcehelp.tableau.com (opens in a new tab)
- Collect Data with the Tableau Server Repositoryhelp.tableau.com (opens in a new tab)
- Create Custom Administrative Viewshelp.tableau.com (opens in a new tab)
- Data Quality Warning Historyhelp.tableau.com (opens in a new tab)
- When is a user's row removed from the TS Users data source?
- Why should the Admin Insights data sources stay inside the Admin Insights project?
- When does the _background_tasks table lose its rows?
- What does disabling repository access with TSM leave open?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Tableau Consultant pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 38 lessons of the Tableau Consultant guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Practice exams purchase adds inline bank questions and topic practice (7 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