Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
Here's your Data + AI Summit 2024 - Warehousing & Analytics recap as you use intelligent data warehousing to improve performance and increase your organization’s productivity with analytics, dashboards and insights.
Keynote: Data Warehouse presente...
How can I add a break line between data labels in Visualization Editor?Not seeing anything in the documentation that helpsI would like the data labels in the example below to show as:trade count: 223Price: 84.71875
how do we apply/add/make Interactive actions in databricks dashboard on tabular chart. here is my case,I have 2 datasets like below,customer tableCustomer region_cdAA GABB CNRegion tableregion_cd name PINGA Georgia 12345 in dashbaord i have 2 pane o...
Hi @boopa45 ,If I understood your requirements correctly you're looking for cross-filtering behaviour. Here's a couple of examples:Cross-filtering for AI/BI dashboards - Databricks Community - 82912Next-Level Interactivity in AI/BI Dashboards | Datab...
I do not see the option as mentioned in the documentation here: https://docs.databricks.com/aws/en/dashboards/#:~:text=Download%20results%E2%80%8B,final%20file%20download.Please let me know if PNG is the only available option currently?
Hi @amdata ,It was possible until recently There's a bug and databricks team is working on a fix. So soon they should release a fix and then you will be able to export to csv as stated in documentation. Check below thread for more info:ONLY PNG form...
The CSV download option has disappeared from the dashboard canvas, and only the PNG download option remains. The SQL download option is still active.Why did the previously available option disappear?When I select 'View Dataset,' the result I see is t...
Hi @taegyun , @random_user77 It seems that this is a bug. This is a known issue, and the team is working on a fix. Check below thread:ONLY PNG format is available for databricks dashbo... - Databricks Community - 140902
Hi guys,I am trying to use table_changes CDF function in an external SQL function run it from an SQL Warehouse serverless cluster in order to retrieve a set of changes from a given table. Here is the documentation for this fuunction:https://docs.data...
What's worked for us is to use a string variable to construct the query and then use EXECUTE IMMEDIATE to execute the query:DECLARE OR REPLACE VAR QUERY;
SET VAR QUERY = 'SELECT * FROM TABLE_CHANGES("catalog.schema.table", "' || timestamp_start || '"...
how do share the dashboard to user with Limit the data access without create a new dashboard with filler in source qry?is there any other way?example,I have a dashboard it contains 3 location data exampleIndia CanadaUSA I need to give limited acces t...
how do share the dashboard to user with Limit the data access without create a new dashboard with filler in source qry?is there any other way?example,I have a dashboard it contains 3 location data exampleIndia CanadaUSAI need to give limited acces to...
Request: please adjust Databricks AI/BI Dashboard Filter Date Picker built-in style (font size, layout, etc.) so that the full datetime selected for "from" and "to" times are displayed (including all minutes and seconds digits) Why: it is frustrating...
In a Databricks AI/BI dashboard, I have a field with multiple categories (e.g., district-wise sales with 50 districts). How can I display only the top few categories (like the top 10) based on a specific metric such as sales?
This feature is released under the Oct-2025 round-up. Refer the Topic: "Dashboards Top/Bottom N Bar Chart Categories"https://www.databricks.com/blog/whats-new-aibi-october-2025-roundup
I was wondering if anyone has been able to display totals in a Table/Pivot visualization? Similar to what is possible in other BI tools?If I have a table with a bunch of rows and one of the columns is Total Cost, I want to be able to show a Total at ...
Request: option for "Total (Sum)" row for Pivot TablesHi @OndrejHavlicek, your statement and implication appear correct, if I understand accurately.ClarificationThe "Grand Total" line added by the "Display total" checkbox uses the same aggregate func...
Hi Databricks community,I’ve created a catalog called azure_data_factory and a database called studytube_azure_mysql_production. Within that database, I have three tables: academies, academy_naming_settings, and users.See the left side of the screens...
Hi @szymon_dybczak and @Raman_Unifeye ,Thanks for answering my questions. I have granted the same permissions for both catalogues:USE CATALOGUSE SCHEMA on the schemas under both cataloguesSELECT on the tables under both schemas and cataloguesI even ...
Dear colleagues,I'm in need of finishing a dashboard with the new databricks dashboard structure, released somewhat recently. On it, I'll have some calculations which need to be percentages over certain partitions, such as `input_amount_percentage_pe...
It is possible to create dynamic parameter lists in Databricks dashboards—so, yes, the documentation is correct, but the crucial detail is that not all data sources or query environments support this feature in the exact same way, and certain limitat...
Hi Databricks community,I'm new to Databricks and I'm trying to connect Databricks to Azure MySQL using Azure Data Factory.When I run the pipeline, I get the following error: ErrorCode=AzureDatabricksCommandError, Hit an error when running the comma...
Could you provide more details about high level flow or design you are planning? Not understanding completely but you can take a look here how to connect ADF with Databricks via PATs -> https://www.sqlshack.com/integrating-azure-databricks-with-azure...
Hi folks, I am creating a SQL dashboard and want to know if I can re-use datasets within the same dashboard. The screenshot below captures what I would like to do pretty well, but to summarize... I need to run an computationally expensive query and w...
AgreementYes, a feature to support nested datasets in Databricks AI/BI dashboards would seem convenient, e.g. as in both examples in the OP's screenshot.Specific needA use case that comes to mind would be to avoid the maintenance of parallel code acr...
Hi community,we have several databricks workspaces per different teams and in each workspace several use case covered.How can we trace the costs per individual use cost for SQL Warehosue / serverless in case we use one SQL warehouse per workspace to ...
You have two related questions on Databricks SQL Warehouse (serverless) cost attribution and resource sharing across workspaces. Here’s a clear answer based on current Databricks capabilities and industry practice.
Tracing Costs per Use Case (SQL War...