Carl Cervone

Import crypto-ecosystems as a BQ dataset and use as a project source

1

### What is it? https://github.com/electric-capital/crypto-ecosystems

Improve performance of `timeseries_metrics_by_artifact_v0`

2

### What is it? This table is too big to query efficiently. We can't even export it to BigQuery. A few things: - We should look to better partitions and...

Get funding events flowing into timeseries metrics

2

### What is it? We want timeseries metrics for funding events, probably with some semantic conventions that concatenate the `FUNDER` and `MECHANISM` into the stem of the `metric_name` and then...

Review contract discovery logic in `int_contracts_by_project`

2

### What is it? *Copied over from comments on #3037* @ravenac95 Would you be able to have a look at the `int_deployers_by_project` and especially `int_contracts_by_project` logic. I have a hunch...

Use `author` instead of `actor_login` where possible for commit events

1

### What is it? Our current contributor metric calculates counts based on the `actor_login` field. However, GitHub’s approach uses the `author_login`, which can lead to discrepancies. In many commit events,...

Update docs to include funding event tutorial and metrics queries for Retro Funding

1

### What is it? We have a place holder for a funding event tutorial. We also need to update the docs to include the new metric ids for retro funding...

Bring Gitcoin RegenData into SQLMesh

1

### What is it? The data is already in BigQuery, now we need to create the seed data and staging models for bringing it into our new pipeline. We should...

Prompt: --- I'd like to create a marimo notebook @superchain-chainlink-case.py in the style of a @value-chain.py template that looks at chainlink's impact along the following dimensions: 1. Direct Contract Interactions:...