chore(weave): Add materialized views that will make it easier to do billing calculations #2636
Conversation
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
… billing calculations.
|
Preview this PR with FeatureBee: https://beta.wandb.ai/?betaVersion=140747497c8ed5c2cc8efed8b9c117a63aeea283 |
tssweeney
reviewed
Oct 8, 2024
tssweeney
reviewed
Oct 8, 2024
tssweeney
reviewed
Oct 8, 2024
| started_at SimpleAggregateFunction(any, Nullable(DateTime64(3))), | ||
| attributes_size_bytes SimpleAggregateFunction(any, Nullable(UInt64)), | ||
| inputs_size_bytes SimpleAggregateFunction(any, Nullable(UInt64)), | ||
| input_refs SimpleAggregateFunction(groupArrayArray, Array(String)), |
There was a problem hiding this comment.
not sure if you wanted to trim down the fields, but you could probably drop many of these if we just want the size stats.
There was a problem hiding this comment.
felt easier to include them..they might come in handy for quick analysis? we can always drop them later. easier to drop than include later as backfills are hard.
tssweeney
reviewed
Oct 8, 2024
…zed_billing_views
…weave into adrian/materialized_billing_views
|
@tssweeney Finally got around to testing this -- all working ok. |
adrnswanberg
changed the title
…weave into adrian/materialized_billing_views
…weave into adrian/materialized_billing_views
tssweeney
approved these changes
Nov 7, 2024
tssweeney
requested changes
Nov 7, 2024
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Description
Add materialized views that provide usage stats for our major tables.
Testing
How was this PR tested?
Locally with a clickhouse server