Exporting Databricks Expense Data and Reports to Excel

KopiCloud Azure Databricks Cost tool automatically creates Excel files whenever we retrieve Azure & Databricks Expenses or generate a report.
These Excel files are stored inside the Data folder, located inside the folder where we installed the tool.

Azure & Databricks Expense Data Excel Files

After we generated Azure & Databricks Expense Data, the application created the Excel files automatically inside the Data folder and/or Azure Storage Account.

The tool created folders for daily reports with the expense year and month in the format yyyy-mm (e.g. 2023-12).
For monthly reports, the folder name used the format yyyy-mm-Total (e.g. 2023-12-Total).

Azure & Databricks Daily Filenames:

Azure Expenses file format: dbx-azure-cost-daily-yyyy-mm-dd-subscription.xlsx
Databricks Cluster file format: dbx-cluster-data-daily-yyyy-mm-dd-workspace.xlsx
Databricks SQL Warehouse file format: dbx-sql-warehouse-data-daily-yyyy-mm-dd-workspace.xlsx
Databricks Computer Job file format: dbx-computer-job-data-daily-yyyy-mm-dd-workspace.xlsx

Azure & Databricks Monthly Filenames:

Azure Expenses file format: dbx-azure-cost-total-yyyy-mm-dd-subscription.xlsx
Databricks Cluster file format: dbx-cluster-data-total-yyyy-mm-dd-workspace.xlsx
Databricks SQL Warehouse file format: dbx-sql-warehouse-total-daily-yyyy-mm-dd-workspace.xlsx
Databricks Computer Job file format: dbx-computer-job-total-daily-yyyy-mm-dd-workspace.xlsx

Databricks Report Excel Files

After we generated Databricks Reports, the application created the Excel files automatically inside the Data folder and/or Azure Storage Account.

Databricks Report Filenames:

Report Total Databricks Cost (daily) file format: dbx-daily-databricks-cost-yyyy-mm-dd-to-yyyy-mm-dd.xlsx
Report Total Databricks Cost (monthly) file format: dbx-total-databricks-cost-yyyy-mm-dd-to-yyyy-mm-dd.xlsx
Report Cost per Databricks Cluster file format: dbx-cost-per-cluster-yyyy-mm-dd-to-yyyy-mm-dd.xlsx
Report Cost per Databricks Computer Job file format: dbx-cost-per-job-yyyy-mm-dd-to-yyyy-mm-dd.xlsx
Report Single Databricks Cluster Cost file format: dbx-single-cluster-cost-clusterid-[cluster-id]-yyyy-mm-dd-to-yyyy-mm-dd.xlsx
Report Cost per Owner file format: dbx-cost-per-owner-yyyy-mm-dd-to-yyyy-mm-dd.xlsx

Note

For detailed information about the content of the Excel files enumerated in this document, please check the Generating Azure Databricks Expenses Data and Generating Azure Databricks Cost Reports sections in Docs.