xmetric vs Lightdash: Local File Exploration vs YAML-Governed Warehouse BI

Why Lightdash requires a warehouse and YAML pipeline before you can explore a file

Lightdash is built as a governed semantic exploration layer where tables, dimensions, and metrics are defined in dbt YAML (schema.yml) or standalone Lightdash YAML files (dbt is optional) over a connected SQL data warehouse (BigQuery, Postgres, Supabase, Redshift, Snowflake, Databricks, Trino, ClickHouse, DuckDB, or Athena).

When a founder, finance lead, or analyst receives a raw CSV export from Stripe or a .twbx workbook from a consultant, loading that file into a warehouse and writing YAML definitions just to check a few metrics takes extra setup.

In xmetric, you work with files and formulas directly in your browser:

1. Drop a .csv, .xlsx, .parquet, or .twbx file into the xmetric app and drag dimensions and measures onto Rows, Columns, Color, and Detail shelves.
2. Drop a .twbx or .twb file into the workbook inspector to list every data source, sheet, dashboard, and calculated field, and save the packaged data files from a .twbx.
3. Test ad-hoc Level of Detail (FIXED, INCLUDE, EXCLUDE) or table calculation formulas in the formula playground without opening a git pull request.

Prototyping metrics in xmetric before committing them to dbt or Lightdash SQL

Even if your company uses Lightdash in production, xmetric is a quick scratchpad for prototyping new metric logic on a file before translating it into a dbt model or Lightdash YAML metric.

Prototype in xmetric (Repeat Customer Revenue Share via FIXED LOD):

SUM(IF { FIXED [Customer ID] : COUNTD([Order ID]) } > 1 THEN [Revenue] ELSE 0 END)
/ SUM([Revenue])

Equivalent SQL to commit to your dbt model (models/marts/fct_customer_orders.sql):

WITH customer_order_counts AS (
  SELECT
    customer_id,
    COUNT(DISTINCT order_id) AS lifetime_orders
  FROM {{ ref('stg_orders') }}
  GROUP BY customer_id
)
SELECT
  o.order_id,
  o.customer_id,
  o.order_date,
  o.revenue,
  CASE WHEN c.lifetime_orders > 1 THEN o.revenue ELSE 0 END AS repeat_customer_revenue
FROM {{ ref('stg_orders') }} o
JOIN customer_order_counts c ON o.customer_id = c.customer_id

Spec comparison: xmetric vs Lightdash