ts-convert-from-snowflake-sv

Convert Snowflake Semantic View DDL into ThoughtSpot TML models via REST API.

3|7|Updated Apr 23, 2026
One-click install
npx skills add https://github.com/thoughtspot/thoughtspot-agent-skills --skill ts-convert-from-snowflake-sv
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ts-convert-from-snowflake-sv
Source: https://github.com/thoughtspot/thoughtspot-agent-skills/tree/main/agents/claude/ts-convert-from-snowflake-sv
Command: npx skills add https://github.com/thoughtspot/thoughtspot-agent-skills --skill ts-convert-from-snowflake-sv

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Reverse-engineering a Snowflake Semantic View into a ThoughtSpot Model by reading the semantic view DDL, mapping tables and joins, translating SQL expressions to ThoughtSpot formulas, and importing the model via the ThoughtSpot REST API.

Core Features & Use Cases

  • Reverse-engineer Snowflake SVs into ThoughtSpot Models, supporting both existing ThoughtSpot Tables and creation of new ones
  • Parse DDL, map relationships, translate expressions, and build/import a ThoughtSpot Model via REST API
  • Merge multiple semantic views and handle conflicts or schema gaps with guidance and validation

Quick Start

Invoke the ts-convert-from-snowflake-sv skill on a Snowflake SV and follow prompts to authenticate, select mode, identify SVs, generate TML, and import or write to file.

Frequently Asked Questions about ts-convert-from-snowflake-sv

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I convert a Snowflake semantic view to a ThoughtSpot model?

To convert a Snowflake semantic view to a ThoughtSpot model, this skill reverse-engineers the view's DDL by mapping tables and joins, translating SQL expressions to ThoughtSpot formulas, and importing the model via the ThoughtSpot REST API.

Can I merge multiple Snowflake semantic views into one ThoughtSpot model?

Yes, you can merge multiple Snowflake semantic views into a single ThoughtSpot model. The process handles conflicts and schema gaps during the multi-view workflow by providing validation and guidance.

Do I need existing ThoughtSpot tables to import a Snowflake semantic view?

You do not need existing ThoughtSpot tables to import a Snowflake semantic view. The conversion supports both mapping to existing ThoughtSpot tables and creating new ones, outputting TML models and optional Table TMLs.

What is needed to generate ThoughtSpot TML from a Snowflake semantic view?

Generating ThoughtSpot TML from a Snowflake semantic view requires ThoughtSpot authentication, an active Snowflake connection, and a defined semantic view. The skill parses the DDL to produce the TML model output.

How are SQL expressions translated when converting Snowflake semantic views?

SQL expressions are translated when converting Snowflake semantic views by reverse-engineering the view's DDL and mapping the SQL logic directly into equivalent ThoughtSpot formulas within the generated TML model.

Can I manually import a ThoughtSpot model generated from a Snowflake view?

Yes, you can manually import a ThoughtSpot model generated from a Snowflake view. The skill outputs a TML model and optional Table TMLs that can be written to a file for manual import instead of using the REST API.