oso icon indicating copy to clipboard operation
oso copied to clipboard

Docs: create a dbt model -> produce a chart in plasmic

Open ccerv1 opened this issue 9 months ago • 2 comments

What is the improvement or update you wish to see?

Docs that guide a user from publishing a dbt model to getting the data available in the API to creating a charting component in Plasmic

Is there any context that might help us understand?

There are enough steps that I can probably find my way through it 50% of the time but a walkthrough doc plus a video would be an incredible resource

Does the docs page already exist? Please link to it.

No response

ccerv1 avatar Apr 26 '24 15:04 ccerv1

I really like this idea!! The event data provider abstraction was made before we had dbt, so we had to format the data in a particular way for the client-side component

Now that we have dbt, we can pre compute the transforms for any chart! And then the client-side component can be really dumb. Thanks for the push, we should do this

ryscheng avatar Apr 27 '24 03:04 ryscheng

I’ll probably start with re-factoring the existing event data provider for our time series charts, then write a doc around it

ryscheng avatar Apr 27 '24 03:04 ryscheng

@ccerv1 Thinking through this issue --- it was filed in a previous era where we didn't really have this notion of time-series metrics. Rather, we only had an event table and the only way to generate charts was to define simple aggregations over this event table.

With metrics_v0 and timeseries_metrics_by_*, we now have the ability to write arbitrary metrics. As long as they get unioned into these tables, they will show up automatically in our chart widget

So I can see this issue go 1 of 2 ways:

  1. It's deprecated, kinda obsolete now --- we just coach people towards writing their metrics to conform to our metrics marts.
  2. Maybe we write more in our "How OSO works" to describe the general architecture of translating raw data => event table => time series metrics => marts.. But this is probably a new issue to refresh these pages.

Anything else we want to do before closing this?

ryscheng avatar Aug 31 '24 00:08 ryscheng