cloudthinker-ai Managing Tableau
Manage and monitor Tableau Server/Cloud — workbooks, data sources, extract refreshes, and site administration.
Discovery Phase
#!/bin/bash
TABLEAU_API="$TABLEAU_SERVER_URL/api/3.21"
# Authenticate
TOKEN=$(curl -s -X POST "$TABLEAU_API/auth/signin" \
-H "Content-Type: application/json" \
-d "{\"credentials\":{\"personalAccessTokenName\":\"$TABLEAU_TOKEN_NAME\",\"personalAccessTokenSecret\":\"$TABLEAU_TOKEN_SECRET\",\"site\":{\"contentUrl\":\"$TABLEAU_SITE_ID\"}}}" \
| jq -r '.credentials.token')
SITE_ID=$(curl -s -X POST "$TABLEAU_API/auth/signin" \
-H "Content-Type: application/json" \
-d "{\"credentials\":{\"personalAccessTokenName\":\"$TABLEAU_TOKEN_NAME\",\"personalAccessTokenSecret\":\"$TABLEAU_TOKEN_SECRET\",\"site\":{\"contentUrl\":\"$TABLEAU_SITE_ID\"}}}" \
| jq -r '.credentials.site.id')
AUTH="X-Tableau-Auth: $TOKEN"
echo "=== Site Info ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID" \
| jq '{name: .site.name, state: .site.state, contentUrl: .site.contentUrl}'
echo ""
echo "=== Workbooks ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID/workbooks?pageSize=15" \
| jq -r '.workbooks.workbook[] | [.id, .name, .project.name, .updatedAt] | @tsv' | column -t
echo ""
echo "=== Data Sources ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID/datasources?pageSize=15" \
| jq -r '.datasources.datasource[] | [.id, .name, .type, .updatedAt] | @tsv' | column -t
echo ""
echo "=== Projects ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID/projects?pageSize=15" \
| jq -r '.projects.project[] | [.id, .name, .contentPermissions] | @tsv' | column -t
Analysis Phase
#!/bin/bash
TABLEAU_API="$TABLEAU_SERVER_URL/api/3.21"
# Re-use TOKEN and SITE_ID from discovery
AUTH="X-Tableau-Auth: $TOKEN"
echo "=== Extract Refresh Tasks ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID/tasks/extractRefreshes?pageSize=15" \
| jq -r '.tasks.task[] | [.extractRefresh.id, .extractRefresh.type, .extractRefresh.datasource.name // .extractRefresh.workbook.name, .schedule.name] | @tsv' | column -t
echo ""
echo "=== Recent Jobs (last 24h) ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID/jobs?pageSize=15" \
| jq -r '.backgroundJobs.backgroundJob[] | [.id, .jobType, .status, .completedAt // "running", .progress] | @tsv' | column -t | head -15
echo ""
echo "=== Failed Jobs ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID/jobs?filter=status:eq:Failed&pageSize=10" \
| jq -r '.backgroundJobs.backgroundJob[] | [.id, .jobType, .createdAt, .statusNotes[:60]] | @tsv' | column -t
echo ""
echo "=== Users ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID/users?pageSize=15" \
| jq -r '.users.user[] | [.id, .name, .siteRole, .lastLogin] | @tsv' | column -t
echo ""
echo "=== Schedules ==="
curl -s -H "$AUTH" "$TABLEAU_API/sites/$SITE_ID/schedules?pageSize=10" \
| jq -r '.schedules.schedule[] | [.name, .type, .frequency, .state, .nextRunAt] | @tsv' | column -t
Output Format
SITE
Name: <site-name>
State: <state>
WORKBOOKS
ID Name Project Updated
<id> <workbook-name> <project-name> <timestamp>
DATA SOURCES
ID Name Type Updated
<id> <ds-name> <type> <timestamp>
FAILED JOBS
ID Job Type Created Error
<id> <type> <timestamp> <message>
EXTRACT REFRESHES
ID Type Source Schedule
<id> <type> <source-name> <schedule>
Anti-Hallucination Rules
- NEVER assume resource names — always discover via CLI/API in Phase 1 before referencing in Phase 2.
- NEVER fabricate metric names or dimensions — verify against the service documentation or
--helpoutput. - NEVER mix CLI commands between service versions — confirm which version/API you are targeting.
- ALWAYS use the discovery → verify → analyze chain — every resource referenced must have been discovered first.
- ALWAYS handle empty results gracefully — an empty response is valid data, not an error to retry.
Counter-Rationalizations
| Shortcut | Counter | Why |
|---|---|---|
| "I'll skip discovery and check known resources" | Always run Phase 1 discovery first | Resource names change, new resources appear — assumed names cause errors |
| "The user only asked for a quick check" | Follow the full discovery → analysis flow | Quick checks miss critical issues; structured analysis catches silent failures |
| "Default configuration is probably fine" | Audit configuration explicitly | Defaults often leave logging, security, and optimization features disabled |
| "Metrics aren't needed for this" | Always check relevant metrics when available | API/CLI responses show current state; metrics reveal trends and intermittent issues |
| "I don't have access to that" | Try the command and report the actual error | Assumed permission failures prevent useful investigation; actual errors are informative |