Contribute with SQLMesh

OSO uses SQLMesh to manage our data models. SQLMesh is a powerful open-source SQL transformation framework that enables you to develop, test, and deploy SQL-based data transformations with confidence.

This section provides a comprehensive guide to contributing data models to OSO using SQLMesh.

Getting Started

Quickstart: Contribute Your First Model

A step-by-step tutorial to get you up and running with a simple "hello world" data model.

Core Concepts

Core Data Modeling Concepts

Learn about entities, events, metrics, and the hierarchical structure of our data models.

How-To Guides

Contribute a Data Model

The complete workflow for designing, implementing, and submitting a new data model.

Create a Time-Series Metric

A focused guide on adding a new time-series metric using the metrics factory.

Test and Validate Models

Learn how to test your models locally with DuckDB and Trino.

Reference

Model Configuration

Details on naming conventions, materialization, partitioning, and grain settings.

Metrics Factory Macros

A complete reference for all special @metrics_* macros.

Time-Series Factory Internals

A deep dive into the technical implementation of the metrics factory.