Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Create new derived query for Firefox-CI worker costs #5759

Open
ahal opened this issue Jun 6, 2024 · 0 comments
Open

Create new derived query for Firefox-CI worker costs #5759

ahal opened this issue Jun 6, 2024 · 0 comments

Comments

@ahal
Copy link
Member

ahal commented Jun 6, 2024 •
edited by data-sync-user
Loading

I'd like to be able to query how much a worker in Firefox-CI costs us. This data is readily available in the billing table, but a derived query can provide us a much simpler view as well as make it easier to build dashboards in Looker.

┆Issue is synchronized with this Jira Task
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 6, 2024
@ahal
feat: Create new derived query for Firefox-CI worker costs
12d2b55 
Issue: mozilla#5759
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 6, 2024
@ahal
feat: Create new derived query for Firefox-CI worker costs
9076b46 
Issue: mozilla#5759
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 10, 2024
@ahal
feat: Create new derived query for Firefox-CI worker costs
fd29dc3 
Issue: mozilla#5759
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 11, 2024
@ahal
feat: Create new derived query for Firefox-CI worker costs
7416d6e 
Issue: mozilla#5759
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 11, 2024
@ahal
feat: Create new derived query for Firefox-CI worker costs
cd86d60 
Issue: mozilla#5759
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 11, 2024
@ahal
feat: Create new derived query for Firefox-CI worker costs
8bcbadc 
Issue: mozilla#5759
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 14, 2024
@ahal
feat: Create new derived query for Firefox-CI worker costs
79fd39f 
Issue: mozilla#5759
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 14, 2024
@ahal
feat: Create new derived query for Firefox-CI worker costs
bd1b0a6 
Issue: mozilla#5759
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 19, 2024
@ahal
fix(fxci): Normalize 'resource.name' in fxci_derived.worker_costs_v1
ab42212 
It seems that the `resource.name` field from the billing export can
sometimes take the form:

    projects/<id>/instances/<name>

And other times it's simply:

    <name>

Update the worker costs query to account for this.

Issue: mozilla#5759
@ahal ahal mentioned this issue Jun 19, 2024
Merged
5 tasks
ahal added a commit to ahal/bigquery-etl that referenced this issue Jun 19, 2024
@ahal
fix(fxci): Normalize 'resource.name' in fxci_derived.worker_costs_v1
13a3d58 
It seems that the `resource.name` field from the billing export can
sometimes take the form:

    projects/<id>/instances/<name>

And other times it's simply:

    <name>

Update the worker costs query to account for this.

Issue: mozilla#5759
akkomar added a commit that referenced this issue Jun 21, 2024
@ahal @akkomar
fix(fxci): Normalize 'resource.name' in fxci_derived.worker_costs_v1 (#…
624d8b4 
…5809)

It seems that the `resource.name` field from the billing export can
sometimes take the form:

    projects/<id>/instances/<name>

And other times it's simply:

    <name>

Update the worker costs query to account for this.

Issue: #5759

Co-authored-by: akkomar <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ahal