# ts-convert-from-snowflake-sv

> Claude/Codex skill by [@thoughtspot](https://omgskills.com/library/thoughtspot/index.md) · 6 stars · Updated 2026-11-01

Convert 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.

## Install

```sh
git clone https://github.com/thoughtspot/thoughtspot-agent-skills /tmp/thoughtspot-agent-skills && ln -s /tmp/thoughtspot-agent-skills/agents/cli/ts-convert-from-snowflake-sv ~/.claude/skills/ts-convert-from-snowflake-sv
```

## From README

Snowflake Semantic View → ThoughtSpot Model Converts a Snowflake Semantic View into a ThoughtSpot Model. Reads the semantic view DDL via GETDDL, then uses three deterministic CLI commands — ts snowflake parse-sv (DDL → structured JSON), ts snowflake translate-formulas (SQL → ThoughtSpot formulas), and ts snowflake build-model (JSON → Model TML + import) — to map tables, relationships, dimensions, and metrics to ThoughtSpot TML. Two scenarios are supported: Scenario A (existing tables): ThoughtSpot Table objects already exist for the Snowflake objects the semantic view references. Reuses those existing Table objects. Scenario B (new tables): No ThoughtSpot Table objects exist yet for the Snowflake objects the semantic view references. Creates new Table objects pointing to those objects. Ask one question at a time for dependent decisions (each answer narrows the next — target database, then schema, then table). Batch independent questions when possible — e.g.

## Links

- HTML page: https://omgskills.com/library/thoughtspot/thoughtspot-agent-skills/ts-convert-from-snowflake-sv/
- GitHub: https://github.com/thoughtspot/thoughtspot-agent-skills
- Author: [@thoughtspot](https://omgskills.com/library/thoughtspot/index.md)

## More from this repo

- [ts-object-answer-promote](https://omgskills.com/library/thoughtspot/thoughtspot-agent-skills/ts-object-answer-promote/index.md) — Promote formulas and parameters from a saved ThoughtSpot Answer into a Model — makes them available to all users who...
   - [@thoughtspot](https://omgskills.com/library/thoughtspot/index.md) · 6 stars
- [ts-coach-model](https://omgskills.com/library/thoughtspot/thoughtspot-agent-skills/ts-coach-model/index.md) — Comprehensively prepare a ThoughtSpot Model for Spotter — review existing AI context, synonyms, and description for...
   - [@thoughtspot](https://omgskills.com/library/thoughtspot/index.md) · 0 stars

## More skills by this author

- [get-developer-docs-reference](https://omgskills.com/library/thoughtspot/spottercode-mcp-plugin/skills/get-developer-docs-reference/index.md) — Guidance for searching general ThoughtSpot developer documentation
   - [@thoughtspot](https://omgskills.com/library/thoughtspot/index.md) · 1 stars
