Raymond Cheng

- column lineage - seeing schema changes - test-deploy / playground in duckdb - generated models per network

Going to backlog this for now, sqlmesh is working on Clickhouse integrations, but its not ready yet. There's only BigQuery, duckdb, and postgres

Updated scope: @ravenac95 got this working off a sqlmesh branch. Remaining work is to have it orchestrated by Dagster

Going to P2 this for now. We should just use #infrastructure in Discord to coordinate manual "locks"

https://kermankohli.substack.com/p/arbitrums-85m-growth-campaign?r=30w0j0&utm_campaign=post&utm_medium=web&triedRedirect=true

There's lots of materials on causal inference: - https://matheusfacure.github.io/python-causality-handbook/landing-page.html - https://www.hsph.harvard.edu/miguel-hernan/causal-inference-book/ - https://aayushmnit.com/posts/2022-09-19-SyntheticControl/2022-09-19_SyntheticControl.html Which is related to the broader field of econometrics - https://www.aeaweb.org/conference/cont-ed/2017-webcasts - https://www.aeaweb.org/conference/cont-ed/2020-webcasts - https://www.mostlyharmlesseconometrics.com/ - https://www.masteringmetrics.com/

Starting some thoughts here https://docs.google.com/document/d/1S7jqzB_JkAyygZ7z3z6m5TVmBZWza7ngMlrrWASs0wA/edit

As per convo with @ccerv1 , he's going to cover this in his talk and in the blog post. I'm going to move this back to the previous sprint and...

https://www.openblocklabs.com/research/arbitrum-ltipp-efficacy-analysis

According to @ravenac95 this is a nice to have, not necessary until we start experiencing bugs in how we do pointer management in BigQuery, adding partitioned keys (for every hour)...