Azure cost managment data exported directly into databricks

Question

Is there any way to export azure cost management data directly in databricks and flatten tags which is string column as json object into df columns.

Answer 1

Is there any way to export azure cost management data directly in databricks?

No, we cannot export azure cost management data directly in databricks.

You can download a daily breakdown of your Azure usage and charges in the Azure portal. You can also get your usage data using Azure CLI.

Only certain roles have permission to get Azure usage information, like the Account Administrator or Enterprise Administrator.

Download usage from the Azure portal (.csv):

1. Sign in to the Azure portal.
2. Search for Cost Management + Billing.
   
3. Depending on your access, you might need to select a Billing account or Billing profile.
4. In the left menu, select Invoices under Billing.
5. In the invoice grid, find the row of the billing period corresponding to the usage you want to download.
6. Select the download icon or the ellipsis (...) on the right.
   
7. The Download pane opens on the right. Select Download from the Usage Details section.