Raymond Cheng

awesome-oso for tracking community work

1

### What is it? We should track an awesome-list of cool things people have built with OSO, including: - API integrations (like Gitcoin) - Cool dashboards (like for ThankArb) -...

### What is it? Some of this content will be redundant with the new pages we're creating. We should trim this and make it prettier

### What is it? Can be in the docs, linked to the website footer

### What is it? https://www.notion.so/karma3labs/OpenRank-datasets-on-OSO-data-portal-113f0868b1ba8014a3dfdb6380387a0b Here is a summary from the Karma3 folks of data on BQ. Let's replace the current gcs_asset with a bq_dts_asset. They plan on maintaining everything...

Key metrics model in sqlmesh

3

### What is it? Currently we have these legacy `code_metrics_by_project`, and `onchain_metrics_by_project` computed in dbt. With the new metrics factory on sqlmesh, we should create new models. Here's my proposal:...

### What is it? We should also write a blog about the Dagster integration you wrote

### What is it? Explaining how we approached rolling metrics

sqlmesh runs seem to always take hours

8

### What is it? I only wanted to copy 1 column into metrics_v0, and it turned into a multi-hour run. Is there a bug? I guess logging could help determine...

Consider DuckDB / Motherduck for frontend OLAP database

1

### What is it? Currently we use Clickhouse for both sqlmesh + frontend API. Since we are moving to Trino for sqlmesh, we might want to consider duckdb for frontend....

### What is it? In a BigQuery world, it was really easy to just expose all our models as a public data on Analytics Hub. If we move to a...