dt-sfm-finops-focus

Generates DQL queries for FOCUS-formatted cloud billing data in Dynatrace Grail.

Updated Dec 12, 2025
One-click install
npx skills add https://github.com/ricardojjulia/ESACompanion --skill dt-sfm-finops-focus-ricardojjulia
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dt-sfm-finops-focus
Source: https://github.com/ricardojjulia/ESACompanion/tree/main/.github/skills/dt-sfm-finops-focus
Command: npx skills add https://github.com/ricardojjulia/ESACompanion --skill dt-sfm-finops-focus-ricardojjulia

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Writing correct DQL queries against FOCUS-formatted cloud billing data in Dynatrace Grail requires deep knowledge of bucket structures, cost field semantics, provider-specific quirks, and filtering rules. This Skill encodes that expertise so users get accurate, production-ready cost queries without memorizing the data model. ## Core Features & Use Cases - Query Templates: Ready-to-adapt DQL templates for amortized cost, list price, and multi-provider queries across AWS, Microsoft, and Google Cloud. - Cost Field Guidance: Rules for choosing between EffectiveCost, ListCost, ContractedCost, and BilledCost, plus marketplace, tax, credit, and adjustment filtering. - Provider Quirk Handling: Covers Google Cloud SubAccountName parsing, BillingFinal-only ingestion, DST offset rules, and fetch timeframe offsets. - Use Case: A user asks "How much did we spend on AWS last month by account?" and receives a correct DQL query with the right buckets, BillingPeriodStart range filter, marketplace exclusions, and EffectiveCost aggregation. ## Quick Start Ask for a DQL query showing cloud spend for a specific provider, account, team, or time period, and the Skill will generate the correctly filtered query.

Frequently Asked Questions about dt-sfm-finops-focus

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write a DQL query for cloud cost in Dynatrace?▼

Start from the essential template: fetch events from the finops buckets, filter by event.provider and event.type, apply a ChargePeriodStart or BillingPeriodStart timeframe, exclude marketplace and tax charges, then summarize sum(EffectiveCost). Always use scanLimitGBytes:-1.

What is the difference between EffectiveCost and BilledCost in FOCUS?▼

EffectiveCost is amortized cost that spreads upfront commitment payments over the commitment period and is the default for reporting. BilledCost reflects the invoice amount including full upfront charges, and is used only for invoice reconciliation or cash-flow analysis.

Why does my Google Cloud billing query return no data?▼

Google Cloud only provides BillingFinal events ingested the month after the billing period closes. When filtering by BillingPeriodStart, set fetch events from: one month earlier than the analysis month so Grail scans the right ingestion window.

Which Grail buckets contain Dynatrace FinOps billing data?▼

Billing data is split into four buckets by event type and account category: custom_sen_critical_events_finops_draft_prod, draft_nonprod, final_prod, and final_nonprod. Production buckets map to the Infrastructure/Net Ops cost center; all others are non-production.

Why do my DQL cost numbers differ from the AWS or Azure console?▼

Provider dashboards often show list or unblended cost, while DQL queries return amortized EffectiveCost that spreads reservation and savings plan fees over time. The amortized figure is the correct number for reporting; contact #help-finops if discrepancies persist.

How do I filter cloud costs by owning team in DQL?▼

Use the dt_OwnedByTeam field, which holds the standardized internal team name from Dynatrace Teams, for consistent filtering. For exploratory lookups, dt_OwnerTeam accepts any team name variant, and dt_ValidTags identifies untagged resources.