Integrate with Snowflake Semantic Views

ThoughtSpot integrates with Snowflake Semantic Views, allowing you to leverage semantic models defined in Snowflake in ThoughtSpot. This enables centralized metric and business logic management in Snowflake, while providing a seamless analytics experience in ThoughtSpot, by leveraging Snowflake’s semantic layer. The integration is designed for flexibility, efficiency, and to improved data governance and discoverability.

The Snowflake Semantic Views is in Early Access. Contact ThoughtSpot support to enable this feature.

Features:

  • Connect directly to Snowflake Semantic Views from ThoughtSpot.

  • Import semantic models, including metrics, formulas, and column descriptions, into ThoughtSpot.

  • Use imported semantic views as data models for building dashboards, SpotIQ queries, and analytics.

  • Column-level metadata and documentation from Snowflake are automatically pulled into ThoughtSpot.

This integration is separate from dbt integration; you can choose to use either or both, depending on your data modeling strategy.

Integrating with Snowflake

  1. Define Semantic Views in Snowflake:

    1. Create semantic views in Snowflake using their native tools.

    2. Add business logic, metrics, and column descriptions as needed.

  2. Connect ThoughtSpot to Snowflake:

    1. In ThoughtSpot, select Snowflake as your data source.

    2. Choose the relevant database and select the semantic view you want to use.

    3. ThoughtSpot will import the semantic view, including all defined metrics and metadata.

  3. Use in ThoughtSpot

    1. The imported semantic view appears as a data model in ThoughtSpot.

    2. Build dashboards, run queries, and use SpotIQ on top of the imported model.

    3. All business logic and metrics defined in Snowflake are available for analytics in ThoughtSpot.

Was this page helpful?
×