thoughtspot
- 38 skills
- 0 followers
- 6 hours ago last updated
- ▌ TS Audit · thoughtspot bundleScan a ThoughtSpot environment across five angles — AI Readiness, Data Modeling, Human Readiness, Performance, Security — and generate a prioritised audit report with actionable recommendations linking to existing skills.
- ▌ TS Migrate Orgs · thoughtspot bundleMove a tenant Org's bespoke content off its own Table/Model copies onto a governed published Model, then retire the old Org. Use when migrating tenants to the single-model publishing pattern, when a tenant's Answers and Liveboards must be repointed at published objects, or when sizing how many tenants a Sets dependency blocks.
- ▌ TS Publish Orgs · thoughtspot bundlePublish ThoughtSpot Tables, Models, Answers and Liveboards from the Primary Org to target Orgs without copying them — defining the template variables and metadata parameterization that publishing requires — via the `ts publish export/resolve/apply/verify/rollback` CLI pipeline.
- ▌ TS Setup Tenancy · thoughtspot bundleStand up a reproducible multi-tenancy test environment on a ThoughtSpot cluster — Orgs, per-Org groups and users, warehouse tables, and optionally a published Model with per-tenant aliases and column security. Use when you need an environment to try publishing, aliasing, column security or the Org migration against, or to reproduce a bug that needs several Orgs. Builds a chosen scenario (topology / per-org / published / mixed), verifies it, and can tear it down.
- ▌ TS Profile Tableau · thoughtspotSet up and manage Tableau Server/Cloud connection profiles. Use when configuring a new Tableau instance for workbook migration, updating credentials, or testing whether an existing profile is working. Supports password and Personal Access Token (PAT) auth. Credentials are stored securely in the OS keychain.
- ▌ TS Load Source Data · thoughtspot bundleLoad source data (CSV, Tableau download, manifest) into a warehouse. Infers schema, generates synthetic data for schema-only sources, and provisions tables. Snowflake and Databricks supported.
- ▌ TS Object Model Erd · thoughtspot bundleRender an existing ThoughtSpot Model (Model TML + its Table TMLs) into an interactive, self-contained HTML ERD — tables, joins, columns, findings and row-level security — that opens in any browser and is shareable without a ThoughtSpot login. Use when someone wants to chart, visualise, diagram, or review the structure of a Model. Not for editing models or generating TML.
- ▌ TS Security Columns · thoughtspot bundleRestrict which columns a group can see on a ThoughtSpot Table or Model, choosing between the two mechanisms — Column Security Rules (CSR) and column-level sharing (CLS) — per Org, and explaining the trade-off. Use when hiding columns from a tenant or an audience, securing sensitive fields, or deciding which column-security mechanism applies to a published object. Drives the `ts share` and `ts security column-rules` pipelines.
- ▌ TS Convert From Qlik · thoughtspot bundleConvert or import a Qlik Sense app into ThoughtSpot — parses a Qlik app (offline .qvf, or an exported Qlik Engine artifacts directory) into tables, columns, master measures and sheets, generates Table + Model TML and a tabbed Liveboard, translates Qlik measure expressions to ThoughtSpot formulas, validates and imports. Direction is always Qlik → ThoughtSpot. Not for ThoughtSpot → Qlik or standalone TML exports.
- ▌ TS Variable Timezone · thoughtspotManage the ts_user_timezone variable in ThoughtSpot — search current values, or set/remove timezone values at org or user level.
- ▌ TS Dependency Manager · thoughtspot bundleSafely audit, remove, or repoint columns and objects across a ThoughtSpot environment — generates a risk-rated impact report, backs up TML before any change, and supports full rollback.
- ▌ TS Object Model Alias · thoughtspotManage column aliases on a ThoughtSpot Model — language localization, tenant-based renaming, and combined tenant + locale matrices — via the `ts alias export/translate/build/import` CLI pipeline.
- ▌ TS Object Model Coach · thoughtspot bundlePrepare a ThoughtSpot Model to work well with Spotter. Use when you want to improve how a Model responds to natural language queries — reviewing and writing AI context, synonyms, reference questions, business terms, and data model instructions. Mines real language from existing Liveboards, Answers, and optionally Snowflake query history to ground the coaching in how users actually talk about the data.
- ▌ TS Profile Databricks · thoughtspotSet up and manage Databricks connection profiles. Use when configuring a new Databricks workspace, updating credentials, or testing whether an existing profile is working. Supports Service Principal (OAuth M2M) and Personal Access Token auth. Credentials are stored securely in the OS keychain.
- ▌ TS Convert From Looker · thoughtspot bundleConvert a Looker semantic model (LookML project) into ThoughtSpot — parses model + view .lkml files, generates Table TML and Model TML per explore, validates invariants, and imports. Optionally converts LookML dashboards to ThoughtSpot Liveboards. Direction is always Looker → ThoughtSpot.
- ▌ TS Profile Thoughtspot · thoughtspotSet up and manage ThoughtSpot connection profiles. Use when configuring a new ThoughtSpot instance, updating credentials, or testing whether an existing profile is working. Credentials are stored securely in the OS keychain.
- ▌ TS Setup Sv · thoughtspotInstall and upgrade the ThoughtSpot stored procedures used by the semantic view conversion skills (ts-convert-to-snowflake-sv, ts-convert-from-snowflake-sv). Also handles deploying updated skill files from the SKILLS.PUBLIC.SHARED stage to this workspace. Run this once after ts-profile-thoughtspot, and again whenever prompted by another skill that detects an outdated or missing procedure.
- ▌ TS Profile Snowflake · thoughtspotSet up and manage Snowflake connection profiles. Use when configuring a new Snowflake connection, updating credentials, or testing whether an existing profile is working. Supports Python connector (key pair or password) and Snowflake CLI. Credentials are stored securely in the OS keychain.
- ▌ TS Convert From Powerbi · thoughtspot bundleConvert or import a Power BI report into ThoughtSpot — parses the Power BI Project (.pbip) TMDL semantic model and PBIR report, generates Table + Model TML and Answers/tabbed Liveboards, translates DAX (including CALCULATE(ALL) → group_aggregate, and time-intelligence rebuilt with parameters), validates and imports. Direction is always Power BI → ThoughtSpot. Not for ThoughtSpot → Power BI or standalone TML exports.
- ▌ TS Convert From Sisense · thoughtspot bundleConvert or import a Sisense dashboard into ThoughtSpot — parses a captured OFFLINE Sisense bundle JSON ({dashboard, widgets, datamodel}), generates Table + Model TML and Answers/tabbed Liveboard, translates JAQL (aggregations + the deterministic formula subset), validates and imports. Direction is always Sisense → ThoughtSpot. Not for ThoughtSpot → Sisense, and not a live Sisense fetch — the input is a bundle already on disk.
- ▌ TS Object Answer Promote · thoughtspot bundlePromote formulas and parameters from a saved ThoughtSpot Answer into a Model — makes them available to all users who search against it.
- ▌ TS Convert To Snowflake Sv · thoughtspot bundleConvert or export a ThoughtSpot Worksheet or Model into a Snowflake Semantic View. Use when ThoughtSpot is the source and the goal is a Snowflake Semantic View — whether converting metrics and formulas for Cortex Analyst access, generating CREATE SEMANTIC VIEW DDL, writing a .sql file for later execution, or updating an existing Snowflake SV from a changed model. Direction is always ThoughtSpot → Snowflake. Not for Snowflake → ThoughtSpot, standalone TML exports, or adding synonyms/AI context to ThoughtSpot models.
- ▌ TS Object Calendar Builder · thoughtspot bundleBuild ThoughtSpot custom calendars that the native API cannot express — week-aligned fiscal years, 4-4-5 / 4-5-4 / 5-4-4 / 13-period patterns with correct 52/53-week tiling, localized or abbreviated labels, calendar-year vs fiscal-year month labelling, and RLS union calendars spanning multiple tenants. Use whenever someone asks for a retail calendar, a 4-4-5 or 4-5-4 calendar, a fiscal calendar starting on a specific weekday ("first Monday of February"), a 13-period calendar, a custom calendar table for Snowflake, or a per-group calendar resolved by row-level security. Also use when an existing calendar's month labels show the wrong year. Not for standard month-offset fiscal calendars, which the ThoughtSpot API already handles natively.
- ▌ TS Object Model Aggregates · thoughtspot bundleAudit a ThoughtSpot Model's Liveboards and Answers to recommend, generate, and wire aggregate Models (26.6 aggregate-aware routing). Analyses which query shapes repeat, profiles compression against the warehouse, presents a marginal-gain curve, and creates warehouse DDL + aggregate Model TML + the aggregated_models association with confirmation gates.
- ▌ TS Convert To Databricks Mv · thoughtspot bundleConvert or export a ThoughtSpot Worksheet or Model into a Databricks Metric View. Use when ThoughtSpot is the source and the goal is a Databricks Metric View — whether converting metrics and formulas for Databricks AI/BI access, generating CREATE VIEW WITH METRICS DDL, writing a .sql file for later execution, or publishing ThoughtSpot semantics to Unity Catalog. Direction is always ThoughtSpot → Databricks. Not for Databricks → ThoughtSpot, standalone TML exports, or adding synonyms/AI context to ThoughtSpot models.
- ▌ TS Convert From Snowflake Sv · thoughtspot bundleConvert or import a Snowflake Semantic View into ThoughtSpot as a Model. Use when Snowflake is the source and the goal is a ThoughtSpot Model — whether migrating Snowflake metrics and semantic definitions into ThoughtSpot or making a Semantic View available for Spotter and search-based analytics. Direction is always Snowflake → ThoughtSpot. Not for ThoughtSpot → Snowflake, standalone DDL generation, or adding AI context to existing ThoughtSpot models.
- ▌ TS Convert From Databricks Mv · thoughtspot bundleConvert or import a Databricks Metric View into ThoughtSpot as a Model. Use when Databricks is the source and the goal is a ThoughtSpot Model — whether migrating Databricks metrics and semantic definitions into ThoughtSpot or making a Metric View available for Spotter and search-based analytics. Direction is always Databricks → ThoughtSpot. Not for ThoughtSpot → Databricks, standalone DDL generation, or adding AI context to existing ThoughtSpot models.
- ▌ TS Object Model Agentql Query · thoughtspot bundleAsk a question of a ThoughtSpot Model and get the answer as data — write AgentQL (Semantic SQL), validate it to warehouse SQL, execute it, and review the results. Use this whenever someone wants to query a ThoughtSpot Model with AgentQL, turn a natural-language question into AgentQL, see the SQL ThoughtSpot generates for a question, pull rows from a Model programmatically, learn how the AgentQL APIs behave, or build a question set to accuracy-test / regression-test / feature-test AgentQL. Triggers on "query this model", "ask the model", "run AgentQL", "what SQL does ThoughtSpot generate", "get the data for…", even when AgentQL isn't named explicitly.
- ▌ TS Profile Thoughtspot 2 · thoughtspotManage ThoughtSpot connection profiles for Snowflake workspaces — add, list, update, delete, and test profiles. Supports both bearer token and password authentication. Sets up External Access Integration and stores credentials securely using Snowflake Secrets. Token profiles expire after ~24 hours; password profiles remain valid until the password changes.
- ▌ TS Convert To Snowflake Sv 2 · thoughtspotConvert a ThoughtSpot Worksheet or Model into a Snowflake Semantic View by exporting TML, mapping columns and joins, translating formulas, and creating the view via SYSTEM$CREATE_SEMANTIC_VIEW_FROM_YAML.
- ▌ TS Recipe Formula Hms Display Snowflake · thoughtspot bundleCreates four Snowflake scalar UDFs that format integer durations (seconds or minutes) as human-readable time strings — HH:MM:SS, DD:HH:MM:SS, HH:MM, DD:HH:MM — then shows the ThoughtSpot formula syntax to display them in any Model. Use this skill whenever the user asks about displaying durations, formatting elapsed time, converting seconds or minutes to a readable format, showing call duration, handle time, SLA elapsed time, ticket age as HH:MM:SS, or any scenario where an integer count of seconds or minutes should appear as a formatted time string in ThoughtSpot.
- ▌ TS Convert From Snowflake Sv 2 · thoughtspotConvert a Snowflake Semantic View into a ThoughtSpot Model by reading the view DDL, mapping tables and joins, translating SQL expressions to ThoughtSpot formulas, and importing the model via the ThoughtSpot REST API.
- ▌ TS Recipe Formula Business Days Snowflake · thoughtspot bundleCreates three Snowflake scalar UDFs for calculating business-day (weekday-only) date differences and elapsed time, then shows the ThoughtSpot formula syntax to use them in any Model. Use this skill whenever the user asks about weekday date calculations, business day counts, working day differences, SLA tracking, ticket age, order fulfillment time, or wants to exclude weekends from any date difference in ThoughtSpot or Snowflake. ThoughtSpot's built-in diff_days/diff_hours/diff_minutes count calendar days — if a user needs weekday-only equivalents, invoke this skill.
- ▌ TS Convert To Databricks Mv 2 · thoughtspotConvert a ThoughtSpot Model into a Databricks Metric View. Genie Code runtime — runs the same detect-fact-table/build-metric-view/build-view-ddl pipeline as the CLI skill via the vendored databricks_mv_lib notebook (%run), plus ThoughtSpotClient via %run instead of the ts CLI for TML export. Model TML only — Worksheets are not supported by this deterministic path.
- ▌ TS Convert From Databricks Mv 2 · thoughtspotConvert a Databricks Metric View into ThoughtSpot Table and Model TML. Genie Code runtime — runs the same parse/translate/build/lint pipeline as the CLI skill via the vendored databricks_mv_lib notebook (%run), plus ThoughtSpotClient via %run instead of the ts CLI for import.
- ▌
- ▌
- ▌ Analyzing Data With Thoughtspot · thoughtspotAnswers data questions using the ThoughtSpot MCP server against any connected data source, and answers questions needing external/contextual research using web search. Use for any analytics or data-query request, whatever the domain — e.g. "how many signups last month", "show me revenue by region", "what's the average patient wait time", "how many units shipped by warehouse", "what's the trend in publication counts for this topic" — as well as requests that need outside context, like "what's the industry benchmark for X", "what does recent research say about Y", or "how does this compare to public data on Z". Also use for requests combining internal data with external context, e.g. "how does our churn rate compare to the industry average", "is our patient readmission rate above or below the national benchmark", "are we shipping faster than typical warehouse turnaround times", or "how does our revenue growth stack up against competitors this quarter".