Unlock the full potential of your Databricks investment with our Tableau-powered dashboard, designed to provide data teams with a comprehensive, easy-to-understand visualization of their Databricks spending. This intuitive Accelerator delivers real-time insights and granular analytics, enabling informed decision-making and strategic cost management. With secure data integration and customizable features, it's the perfect solution for maintaining financial control and driving efficiency in your Databricks environment.

### Answer Key Business Questions

* What is my quarterly and monthly spend in $USD and DBUs (Databricks Unit)?
* Which of my workspaces are driving the most consumption?
* What time of day is driving the most consumption of my Databricks resources?

### Monitoring and Improving KPIs

* Quarterly Databricks account spend
* Monthly Databricks account spend
* Cost per SKU
* Cost by Day of Week & Time

### Connect to your Databricks data to enable this Accelerator

##### Databricks prerequisite

* You must have the system tables enabled to use this dashboard. ([Databricks documentation](https://docs.databricks.com/en/admin/system-tables/index.html#enable))

##### Tableau configuration

* You will need to use Tableau Desktop to replace the sample data with an extract your own data, but you can either connect to your own data in Tableau Server/Cloud or directly in Desktop.

##### Option 1: Create a published data source in Tableau Server or Tableau Cloud

1. In the Explore tab, select the **New** dropdown and select **Data Source.**
2. Select **Databricks** as your connection
3. Enter your credentials and create a relationship between the `system.billing.usage table` and the `system.billing.list_prices` table.
4. Edit the relationship noodle to match the fields shown in the screenshot. 
    1. For the Usage Start Time equivalent in `list_prices`, click the dropdown menu and select **Create relationship calculation**. Use the syntax from the screenshot - `IFNULL([Price End Time], DATE("1/1/3000"))`.
5. Publish this data source as a extract on your site.
6. Open the accelerator workbook in Tableau Desktop.
7. Create a new data source by clicking on the top menu **Data** \> **New Data Source** and select **Tableau Server** as your data source.
8. Connect to the new extract you generated.
9. In the top menu, select **Data** \> **Replace Data Source** and replace the sample data with the new source you created.

##### Option 2: Create your Databricks connection locally in Tableau Desktop

1. Open the accelerator workbook in Tableau Desktop.
2. Create a new data source by clicking on the top menu **Data** \> **New Data Source.**
3. Select **Databricks** as the data source. [Install the driver](https://docs.databricks.com/en/partners/bi/tableau.html#requirements) if you haven't done so previously.
4. Enter your credentials and create a relationship between the `system.billing.usage table` and the `system.billing.list_prices` table.
5. Edit the relationship noodle to match the fields shown in the screenshot. For the Usage Start Time equivalent in `list_prices`, click the dropdown menu and select **Create relationship calculation**. Use the syntax from the screenshot - `IFNULL([Price End Time], DATE("1/1/3000"))`.
6. Select the **Extract** radio button on the **Data Source** page
7. In the top menu, select **Data** \> **Replace Data Source** and replace the sample data with the new data source you just generated.

Databricks Compute Cost Overview

Understand and control your Databricks account spend.