CloudHealth retrieving cost of Databricks used in AWS
search cancel

CloudHealth retrieving cost of Databricks used in AWS

book

Article ID: 439167

calendar_today

Updated On:

Products

CloudHealth

Issue/Introduction

Within CloudHealth costs for assets run under Databricks will appear across the existing Service Cost Categories. 

Resources spun up through Databricks though will always have a tag of Vendor applied with a value of Data Bricks applied.

Resolution

You can therefore make use of FlexReports to return this cost, resources deployed using Databricks, will include a tag labelled "Vendor", this tag will always have a value of Databricks for resources deployed via Databricks. 

Please make use of the following stub to retrieve Databricks related costs, this will pull any resource with Vendor tag = Databricks and will report Product Name and Unblended cost - 

{
  "sqlStatement": "SELECT timeInterval_Month AS Month, ELEMENT_AT(\"billingTags##tags_as_map\", 'resourcetags/user:vendor') AS billingTags_tags_as_map_resourcetags_user_vendor, lineItem_UsageAccountId AS LineItem_UsageAccountId, product_ProductName AS Product_ProductName, SUM(lineItem_UnblendedCost) AS SUM_lineItem_UnblendedCost FROM AWS_CUR WHERE (ELEMENT_AT(\"billingTags##tags_as_map\", 'resourcetags/user:vendor') IN ('Databricks')) GROUP BY timeInterval_Month, ELEMENT_AT(\"billingTags##tags_as_map\", 'resourcetags/user:vendor'), lineItem_UsageAccountId, product_ProductName",
  "needBackLinkingForTags": true,
  "dataGranularity": "MONTHLY",
  "timeRange": {
    "last": 1,
    "excludeCurrent": true
  },
  "limit": -1
}

Please update the stub further to address your specific use case.