Skip to content

Instantly share code, notes, and snippets.

@dave-connors-3
Created November 17, 2021 14:53
Show Gist options
  • Save dave-connors-3/fdcebb3c994876a790e5b25ada7744b3 to your computer and use it in GitHub Desktop.
Save dave-connors-3/fdcebb3c994876a790e5b25ada7744b3 to your computer and use it in GitHub Desktop.
metrics block of the manifest.json
{
"metrics": {
"metric.claim_to_fame.total_claim_payments": {
"fqn": [
"claim_to_fame",
"marts",
"total_claim_payments"
],
"unique_id": "metric.claim_to_fame.total_claim_payments",
"package_name": "claim_to_fame",
"root_path": "/Users/daveconnors/dev/coalesce/dbt-project-maturity/5-adulthood",
"path": "marts/metrics.yml",
"original_file_path": "models/marts/metrics.yml",
"model": "ref('fct_billed_patient_claims')",
"name": "total_claim_payments",
"description": "total amount paid by the insurance provider",
"label": "Total Claim Payments",
"type": "sum",
"sql": "total_paid_amount",
"timestamp": "created_at",
"filters": [],
"time_grains": [
"day",
"week",
"month"
],
"dimensions": [],
"resource_type": "metric",
"meta": {},
"tags": [],
"sources": [],
"depends_on": {
"macros": [],
"nodes": []
},
"refs": [
[
"fct_billed_patient_claims"
]
],
"created_at": 1637020973
},
"metric.claim_to_fame.total_claim_charges": {
"fqn": [
"claim_to_fame",
"marts",
"total_claim_charges"
],
"unique_id": "metric.claim_to_fame.total_claim_charges",
"package_name": "claim_to_fame",
"root_path": "/Users/daveconnors/dev/coalesce/dbt-project-maturity/5-adulthood",
"path": "marts/metrics.yml",
"original_file_path": "models/marts/metrics.yml",
"model": "ref('fct_billed_patient_claims')",
"name": "total_claim_charges",
"description": "total amount charged to the insurance provider",
"label": "Total Claim Charges",
"type": "sum",
"sql": "total_charge_amount",
"timestamp": "created_at",
"filters": [],
"time_grains": [
"day",
"week",
"month"
],
"dimensions": [],
"resource_type": "metric",
"meta": {},
"tags": [],
"sources": [],
"depends_on": {
"macros": [],
"nodes": []
},
"refs": [
[
"fct_billed_patient_claims"
]
],
"created_at": 1637020973
},
"metric.claim_to_fame.total_billed_diagnoses": {
"fqn": [
"claim_to_fame",
"marts",
"total_billed_diagnoses"
],
"unique_id": "metric.claim_to_fame.total_billed_diagnoses",
"package_name": "claim_to_fame",
"root_path": "/Users/daveconnors/dev/coalesce/dbt-project-maturity/5-adulthood",
"path": "marts/metrics.yml",
"original_file_path": "models/marts/metrics.yml",
"model": "ref('fct_billed_patient_claims')",
"name": "total_billed_diagnoses",
"description": "distinct count of primary diagnoses observed in billed claims",
"label": "Total Billed Diagnoses",
"type": "count_distinct",
"sql": "total_paid_amount",
"timestamp": "created_at",
"filters": [],
"time_grains": [
"day",
"week",
"month"
],
"dimensions": [],
"resource_type": "metric",
"meta": {},
"tags": [],
"sources": [],
"depends_on": {
"macros": [],
"nodes": []
},
"refs": [
[
"fct_billed_patient_claims"
]
],
"created_at": 1637020973
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment