Raymond Cheng

Following work in is to script a PR into oss-directtory

We've gotten contributions from growthepie and RF4 so far. Maybe we just want a transform that will look for empty Project descriptions and query GitHub for found orgs

Related https://stackoverflow.com/questions/56938856/how-do-i-get-usage-data-about-the-what-views-and-datasets-are-being-used-queried

Just summarizing what we've learned, thank you @davidgasquez and @ravenac95 for your input! For OSO teammates, you can do cool things off of `INFORMATION_SCHEMA` https://blog.peerdb.io/five-useful-queries-to-get-bigquery-costs https://stackoverflow.com/questions/56938856/how-do-i-get-usage-data-about-the-what-views-and-datasets-are-being-used-queried https://cloud.google.com/bigquery/docs/information-schema-jobs For external users,...

We also need to create the intermediate and mart models for these users and how they relate to events

Added the user model here https://github.com/opensource-observer/oso/pull/1362 This does not include artifacts_by_user, nor any event aggregation yet

The idea is to share the descriptions with Agora so that they can create impact "profile pages" for each

Going to de-prioritze this for now. The intention was to have MetricFlow do this for us automatically https://github.com/opensource-observer/oso/issues/1179 But MetricFlow turned into a paid cloud product just now, so we...

This is technically done with Cube now! Closing in favor of follow-on work to hook it up to the UI

With gitcoin for their OSS round, we devised a four point check: was the first commit more than 90 days ago has there been a recent commit in the last...