pyoso

WARNING: THIS IS A WORK IN PROGRESS

pyoso is a Python package for fetching models and metrics from OSO. This package provides an easy-to-use interface to interact with oso and retrieve valuable data for analysis and monitoring.

Features

Execute custom SQL queries for analyzing the OSO dataset.
Inspect data dependencies and freshness with an analytics tree.
Semantic modeling layer to build and execute complex queries (optional).

Installation

You can install pyoso using pip:

pip install pyoso

Optional Semantic Modeling

For semantic modeling capabilities, you can install with the semantic extra:

pip install pyoso[semantic]

This will include the oso_semantic package for building semantic models and queries.

Usage

Here is a basic example of how to use pyoso to fetch data directly into a pandas DataFrame:

import os
from pyoso import Client

# Initialize the client with an API key
os.environ["OSO_API_KEY"] = 'your_api_key'
client = Client()

# Fetch artifacts
query = "SELECT * FROM artifacts_v1 LIMIT 5"
artifacts = client.to_pandas(query)

print(artifacts)

Inspecting Data Dependencies

For more advanced use cases, the client.query() method returns a QueryResponse object that contains both the data and analytics metadata. This allows you to inspect the dependency tree of the data sources used in your query.

import os
from pyoso import Client

# Initialize the client
os.environ["OSO_API_KEY"] = "your_api_key"
client = Client()

# Execute a query to get a QueryResponse object
query = "SELECT * FROM artifacts_v1 LIMIT 5"
response = client.query(query)

# You can still get the DataFrame as before
df = response.to_pandas()
print("\n--- Query Data ---")
print(df)

# Now, inspect the analytics to see the dependency tree
print("\n--- Data Dependency Tree ---")
response.analytics.print_tree()

This will output a tree structure showing how the final artifacts_v1 table was constructed from its upstream dependencies, helping you understand the data's origin and freshness.

Documentation

For detailed documentation about the OSO dataset, please refer to the official documentation.

Future Plans

Create DataFrame wrapper for creating SQL query from data transforms

Metadata

Release files for pyoso 0.6.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pyoso 0.6.1
File	Size	Uploaded
pyoso-0.6.1.tar.gz	9.0 kB	Aug 8, 2025	Details

Built distribution (wheel)

Table of built distributions (wheels) for pyoso 0.6.1
File	Interpreter	ABI	Platform	Reset
pyoso-0.6.1-py3-none-any.whl 7.4 kB Aug 8, 2025	Python 3	none	any	Details

Total release size: 16.4 kB

Release files / pyoso-0.6.1.tar.gz

Download URL	pyoso-0.6.1.tar.gz
Size	9.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`865083a34cef2bca58912503dd9f62d037cf1bdd42551c3bcf9af3cbc75c3e80`
BLAKE2b-256 checksum How to use checksums	`a5df80f456c7fad63060744292a185eeae4cc3ec70075c409648acbb10655985`
Upload date	Aug 8, 2025
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`uv/0.7.1`

Release files / pyoso-0.6.1-py3-none-any.whl

Download URL	pyoso-0.6.1-py3-none-any.whl
Size	7.4 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`8d2963b9e4f47286cd811a01969660b592bbf2c557b91cf083e791fac9c1ad99`
BLAKE2b-256 checksum How to use checksums	`204b86e0c37632af7e1798b394b58647112f4fab3d5078d82c669c1f89b31ef3`
Upload date	Aug 8, 2025
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`uv/0.7.1`