Free Developer Tool · Apache Ossie / Dosi

Semantic Model Converter

Convert an Ossie or Dosi YAML semantic model into another platform’s format. Inspect diagnostics, edit the generated files, and download one file or a ZIP.

No signup · Sample models included · Offline conversion checks

Conversion Workbenchomni_sales.yml

Source YAMLomni_sales.yml

Omni Sales · ANSI_SQL

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.

# yaml-language-server: $schema=../../../../core-spec/ossie-schema.json
#
# Fixture A -- all-native round-trip (Ossie -> Omni -> Ossie).
# Star schema; every construct maps to a native Omni slot. Documented
# normalizations on the Ossie -> Omni -> Ossie trip: relationship names are
# regenerated (`<from>_to_<to>`), and unique_keys that merely restate the
# primary key are absorbed by it.

version: "0.2.0.dev0"

name: sales
description: Sales orders with customer attributes
ai_context:
  instructions: "Use this model for order analysis."
datasets:
  - name: orders            # fact: no incoming relationship -> topic base_view
    source: samples.tpch.orders
    primary_key: [o_orderkey]
    description: One row per order
    fields:
      - name: o_orderkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_orderkey
        description: Order identifier
      - name: o_custkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_custkey
      - name: o_orderdate
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_orderdate
        label: Order Date
        dimension:
          is_time: true
        ai_context:
          synonyms: [order date, date]
      - name: o_totalprice
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_totalprice
  - name: customer
    source: samples.tpch.customer
    primary_key: [c_custkey]
    fields:
      - name: c_custkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: c_custkey
      - name: c_name
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: c_name
        description: Customer name
relationships:
  - name: orders_to_customer
    from: orders
    to: customer
    from_columns: [o_custkey]
    to_columns: [c_custkey]
metrics:
  - name: total_revenue
    expression:
      dialects:
        - dialect: ANSI_SQL
          expression: SUM(orders.o_totalprice)
    description: Total order revenue
    ai_context:
      synonyms: [revenue, sales]
  - name: order_count
    expression:
      dialects:
        - dialect: ANSI_SQL
          expression: COUNT(*)
    description: Number of orders

Conversion sends the current YAML to Datus servers. No data source connection or SQL execution is performed.View Original Example

Choose a target and convert to preview temporary files.

One Semantic Model, Multiple Export Formats

A semantic model describes datasets, fields, relationships and metrics. This tool accepts Apache Ossie YAML and supported Dosi extensions, then sends a snapshot to Datus for conversion using Apache Ossie converters with compatibility and quality checks. The generated files are a starting point for import into your target platform.

How to Convert a Semantic Model

Enter YAML or Load an Example
Paste your source model, upload a .yml or .yaml file, or select an Apache Ossie test fixture. The source stays editable.
Choose a Target Platform
Select the export format and fill in any fields marked with an asterisk. Database is optional where offered. A preferred SQL dialect selects an existing expression; it does not translate SQL.
Convert and Review
Click Convert to submit the current input and settings. Success passes the available offline checks. Needs Review includes diagnostics; Blocked results cannot be exported.
Edit and Download
Inspect the generated files in the workbench. Download a single file directly or a multi-file ZIP with relative directories preserved. Downloads include your edits.

Supported Target Formats

The workbench loads its available targets and required options from the conversion service. Exports cover these formats; available targets depend on the deployed engine version.

Snowflake Cortex Analyst
dbt MetricFlow Manifest
Cube
Omni
Microsoft Power BI / Fabric
Sigma
WisdomAI
Hex
Holistics AML
Honeydew
ThoughtSpot TML
GoodData LDM
NVIDIA Auto Ontology
OrionBelt OBML

Try Real Apache Ossie Examples

These unchanged Apache-2.0 test fixtures are pinned to an upstream revision. Select one above to fill the editor and choose a suggested target.

Omni Sales

ANSI_SQL sales model. Suggested target: Omni, producing multiple YAML files for views, relationships and topics.

NVIDIA Sales

ANSI_SQL and Snowflake expressions, including a ratio metric. Suggested target: dbt MetricFlow Manifest, producing a JSON file.

TPC-DS Retail

A larger ANSI_SQL retail model. Suggested target: Snowflake Cortex Analyst. Expected metadata warnings demonstrate the Needs Review flow.

What Conversion Does—and What Still Needs Checking

Conversion does not connect to a warehouse, run SQL or DAX, or deploy files to the target platform. Verify import and execution in that platform.

Some source constructs cannot be represented in every target. Read target-specific notes and diagnostics; do not assume every model converts losslessly.

The dbt target exports semantic_manifest.json, not the source YAML files of a runnable dbt project. Microsoft Power BI / Fabric exports offline BIM JSON.

The public tool accepts up to 1 MiB of UTF-8 input, with server-side request limits. YAML is sent to Datus servers when you click Convert. Inputs and generated files are not persisted by the tool; keep downloads before leaving the page.

Continue Exploring

FAQ

Frequently asked questions

What input does the semantic model converter accept?

The tool accepts Apache Ossie semantic model YAML and supported Dosi extensions, up to 1 MiB of UTF-8 text. Paste a model, upload a .yml or .yaml file, or load an included upstream example. It does not accept an arbitrary vendor configuration as the source; use the separate OSI Playground for its MetricFlow-to-OSI workflow.

Is this a YAML-to-YAML formatter?

No. Conversion maps semantic datasets, fields, relationships and metrics into a target platform’s model format. Output can be YAML, JSON, BIM, AML or TML, depending on the target. Unsupported constructs and possible loss of metadata are reported as diagnostics rather than treated as a formatting change.

Does Success mean the output will run in the target platform?

Success means the available offline conversion and quality checks passed. The tool does not connect to your warehouse, execute SQL or DAX, or deploy to the destination. Import the files into the target platform, configure any required connections, and verify metric results before using the model in production.

Are my YAML files processed in the browser?

The browser holds your editable input and output, but conversion runs on Datus servers. Clicking Convert submits a snapshot of the current YAML and settings. No account is required. The tool does not persist source models or results; refresh or close the page to clear them, and download files you want to keep.

Why do some results show Needs Review or Blocked?

Needs Review means files were generated with warnings, such as metadata that the target cannot preserve. Read the diagnostics before downloading or importing them. Blocked means a conversion or quality problem prevents export. Correct the source or required settings and convert again; selecting a different target can change which constructs are supported.