Semantic layer

A deeper understanding of your data.

A semantic model turns database tables into something your people and your AI understand: friendly names, clear descriptions, the right data types and only the columns that matter. Define it once, and every dashboard, extension and conversation uses it.

In your database

sales_orderssales_orders
  • order_dtdate
  • cust_nointeger
  • zipinteger
  • net_amtdecimal
  • cogsdecimal
  • _etl_loaded_atdatetime

In your semantic model

Orderssales_orders
  • Order datedate
  • Customer numberinteger
  • PostcodeText
  • Net salesdecimal
  • Cost of goods solddecimal

_etl_loaded_at hidden

One model, used everywhere

Define it once. Use it everywhere.

The context you add to a model goes wherever the data goes, so a field means the same thing in every dashboard, every extension and every answer.

Semantic modelOrders · 5 fields
  • Analytics

    Dashboards, KPI cards and spreadsheets show your friendly field names and respect the data types you set.

  • Extensions

    SuperTables, FinanceTables and the other extensions in Analytics read the same fields, with the same names.

  • Vizzy AI

    Vizzy picks the right model for a question and reads your comments to understand what every field means.

Two ways to start

Build it, or bring it.

Model a table straight from one of your database connections, or reuse the models your analysts already maintain in Tableau.

Connection-backed model

Model on your own database

Pick a connection, drag a table onto the model canvas and give it the context it needs. Run the semantic profile and Trulyp suggests what every field means.

  • Snowflake, Databricks, BigQuery, SQL Server and eight more
  • Aliases, comments, data types and hidden columns
  • Data preview and semantic profile while you work
See all databases

Semantic provider

Import from Tableau

Connect Tableau Cloud or Tableau Server once, then import published data sources with all their tables, joins and relationships. Trulyp only reads; nothing is copied.

  • Multiple tables and relationships, ready to use
  • Fields and calculations your analysts already trust
  • Power BI semantic models Coming soon
How Trulyp connects

From Tableau to Trulyp

Your Tableau model, one import away.

Pick a published data source and Trulyp brings in its tables, relationships and calculated fields as a semantic model. Nothing is rebuilt and nothing is copied.

In Tableau

Floraya SalesPublished data source
OrdersProductsStoresCustomers
AbcCollectionAbcStore name#Net sales=#Gross margin %

In Trulyp

Floraya SalesSemantic provider based
OrdersOrder datedateNet salesdecimalGross margin %calc
ProductsCollectionstring
StoresStore namestring
CustomersSegmentstring

4 tables · 3 relationships · read-only

Context for AI

Why Vizzy gets it right.

Vizzy doesn't guess what a column means. It reads your semantic model and turns your question into a query on it, and AI Trace records every step.

  1. Intent

    Vizzy works out what you are asking.

  2. Route

    It picks the semantic model that fits the question.

  3. Context

    Your field names and comments tell it what each column means.

  4. Tool call

    It runs a query on the model, not a guess.

  5. Reply

    You get the answer, with every step recorded in AI Trace.

See AI Trace in action

Semantic modeling

Context, defined once.

Everything you add to a model is used by Analytics, by SuperTables and other extensions, and by Vizzy AI.

  • Names and comments people understand

    Give tables and columns an alias and a description. Analytics shows the names, Vizzy AI reads the comments.

  • Semantic profile

    Trulyp samples your data, tells dimensions from measures, explains what each field likely means and fills in missing comments.

  • The right data type

    Treat postcodes, IDs and codes as Text so nobody adds them up, without changing anything in your database.

  • Only the columns that matter

    Hide technical and load columns from Analytics, extensions and AI, and keep the model clean.

  • Data preview

    Check the first rows of every table while you model, so you know exactly what people will see.

  • Test to production

    Export a model with its aliases, comments and settings, and import it in another environment. Credentials never travel along.

Coming soon

Multi-table models and row-level security.

  • Multi-table models on any connection. Models imported from Tableau already bring several tables and their relationships. Soon you can join tables yourself in models built directly on your database connections.
  • Row-level security. Decide per person or team which rows of a semantic model they can see, in every dashboard and in every answer.