Activating Tags in Billing Reports

# Activate user-defined tags (the step everyone forgets)
aws ce update-cost-allocation-tags-status \
  --cost-allocation-tags-status \
    TagKey=team,Status=Active \
    TagKey=environment,Status=Active \
    TagKey=cost-center,Status=Active

# Verify which tags are active
aws ce list-cost-allocation-tags --status Active

# Query costs grouped by the team tag (only works after activation)
aws ce get-cost-and-usage \
  --time-period Start=2026-04-01,End=2026-04-30 \
  --granularity MONTHLY \
  --metrics UnblendedCost \
  --group-by Type=TAG,Key=team

# Assign the built-in policy that inherits a tag from the resource group
az policy assignment create \
  --name inherit-team-tag \
  --display-name "Inherit team tag from resource group" \
  --policy "cd3aa116-8754-49c9-a813-ad46512ece54" \
  --scope "/subscriptions/YOUR-SUB-ID" \
  --params '{"tagName": {"value": "team"}}'

# Remediate existing resources (applies the tag to what is already deployed)
az policy remediation create \
  --name inherit-team-tag-remediation \
  --policy-assignment inherit-team-tag \
  --resource-discovery-mode ReEvaluateCompliance

-- Cost per team for the current month from BigQuery billing export
SELECT
  (SELECT value FROM UNNEST(labels) WHERE key = 'team') AS team,
  (SELECT value FROM UNNEST(labels) WHERE key = 'environment') AS environment,
  ROUND(SUM(cost), 2) AS cost_usd,
  ROUND(SUM(IFNULL((SELECT SUM(amount)
                    FROM UNNEST(credits)), 0)), 2) AS credits_usd
FROM `my-billing-project.billing_export.gcp_billing_export_resource_v1_XXXXXX`
WHERE _PARTITIONTIME >= TIMESTAMP('2026-04-01')
  AND _PARTITIONTIME <  TIMESTAMP('2026-05-01')
GROUP BY team, environment
ORDER BY cost_usd DESC;