cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
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.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

MadelynM
by Databricks Employee
  • 3457 Views
  • 0 replies
  • 0 kudos

[Recap] Data + AI Summit 2024 - Warehousing & Analytics | Improve performance and increase insights

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...

Screenshot 2024-07-03 at 10.15.26 AM.png
Warehousing & Analytics
AI BI Dashboards
AI BI Genie
Databricks SQL
  • 3457 Views
  • 0 replies
  • 0 kudos
Kaz1
by New Contributor
  • 415 Views
  • 3 replies
  • 1 kudos

Resolved! dataframe.display() doesn't support data aggregation

Error: dataframe.display() doesn't support data aggregation. Use display(dataframe) for better results in Databricks notebooks.But I don't use dataframe.display! I use display(dataframe). This error occurs when creating a visualization in a databrick...

  • 415 Views
  • 3 replies
  • 1 kudos
Latest Reply
SteveOstrowski
Databricks Employee
  • 1 kudos

Hi @Kaz1, I understand the frustration -- the error message is misleading because you ARE already using display(dataframe), which is the correct syntax. Let me explain what is actually happening and how to work around it. WHAT IS HAPPENING When you c...

  • 1 kudos
2 More Replies
a_d
by New Contributor III
  • 493 Views
  • 4 replies
  • 2 kudos

Resolved! flexible Calculated field in Dashboard changing with filters used

Hi guys,I am making a Dashboard where I want to show the AOV per Brand with a date filter to change the days used in the calculation.AOV = sales / ordersI have sales and orders per day and would like to have the AOV dependant on the Days selected.The...

  • 493 Views
  • 4 replies
  • 2 kudos
Latest Reply
Ashwin_DSA
Databricks Employee
  • 2 kudos

Hi @a_d - Thanks for confirming. Here is a good example. I've also tested it and given some snapshots below if it helps. My data looks something like the below.   You can see above the results (on the right side) an option to create a custom calcula...

  • 2 kudos
3 More Replies
Bahjat
by New Contributor III
  • 809 Views
  • 4 replies
  • 2 kudos

Resolved! AI/BI Dashboard Visualization Color Palette not working?

My team and I are building a Dashboard to present to our client (imbedded within an I-frame). Very recently, the color palette of the visualizations as well as the general theme section seem broken. To be more specific, if I try to update the color o...

  • 809 Views
  • 4 replies
  • 2 kudos
Latest Reply
Bahjat
New Contributor III
  • 2 kudos

Thanks for all the input team. I have escalated this through our data bricks support desk and they were able to resolve this quickly. The issue was resolved on Feb 14th 2026.

  • 2 kudos
3 More Replies
sahiljain
by New Contributor II
  • 485 Views
  • 3 replies
  • 1 kudos

Resolved! Translating Embedded Dashboard

Hi, I'm trying to embed a Databricks dashboard, but the language for labels like "Global Filters" always appears as English. Is there a way to make the dashboard display in Japanese when users view it as an iframe?I've already set the dashboard local...

Warehousing & Analytics
embedded dashboards
  • 485 Views
  • 3 replies
  • 1 kudos
Latest Reply
emma_s
Databricks Employee
  • 1 kudos

Hi, to do a feature request you'd need to speak to a member of your account team. If you're not sure who this is talk to your databricks administrator in your organisation.  Thanks, Emma

  • 1 kudos
2 More Replies
meljung
by New Contributor II
  • 1842 Views
  • 2 replies
  • 0 kudos

Resolved! Moving average calculation in Databricks AI/BI dashboard

So, I can't figure out how to do moving average as custom calculation in Databricks dashboard. I'm applying many different filters and the denominator of the metric has to change dynamically based on the chosen filters. So, in this case using `Custom...

Screenshot 2025-06-17 134351.png
  • 1842 Views
  • 2 replies
  • 0 kudos
Latest Reply
davidray
New Contributor II
  • 0 kudos

You’re running into a current limitation in Databricks AI/BI dashboards. Right now, a moving average cannot be applied on top of a Custom Calculation when that metric itself is dynamically recalculated based on filters. Since your denominator changes...

  • 0 kudos
1 More Replies
David_Dabbs
by Databricks Partner
  • 719 Views
  • 3 replies
  • 0 kudos

Resolved! Databricks UUID

Is there a plan for Databricks to support the UUIDv7 variant that is friendlier to use in databases for keys and partitioning?https://python.plainenglish.io/python-3-14-brings-uuidv6-v7-v8-stop-using-uuid4-like-its-2015-90518fdfce81Also, related, Pyt...

  • 719 Views
  • 3 replies
  • 0 kudos
Latest Reply
sarahbhord
Databricks Employee
  • 0 kudos

Hey @David_Dabbs - We do support uuidv7 database keys and partitioning in Lakebase PostgreSQL via pg_uuidv7  and Databricks SQL functions. There are some limitations when it comes to clustering and column generation.  As for Python 3.1.4 - this is an...

  • 0 kudos
2 More Replies
harinair304
by New Contributor
  • 228 Views
  • 1 replies
  • 1 kudos

Resolved! Extracting SQL Query Profiles Programatically/through an API

Currently the only way to extract the DataBricks SQL query profile seems to be via the UI by hitting the download button. Is there any other way to do so??Thanks in advance!!

  • 228 Views
  • 1 replies
  • 1 kudos
Latest Reply
sarahbhord
Databricks Employee
  • 1 kudos

Hello @harinair304 - Today, the only supported way to export the full Databricks SQL query profile JSON is the UI’s Download button. An API has been requested but no committed timeline. Best,  Sarah

  • 1 kudos
sebastianherold
by New Contributor III
  • 921 Views
  • 5 replies
  • 2 kudos

Resolved! Export Databricks Dashboards as PDF / JSON

Hey,currently, there is the function to export AI/BI dashboards as PDF in the UI, but it would be good to also have this option per API. API-first is important for big organizations to scale features. In our case, we want to send a personalized email...

  • 921 Views
  • 5 replies
  • 2 kudos
Latest Reply
sebastianherold
New Contributor III
  • 2 kudos

Thanks for the suggestions.Row level security will not work for us as the datasets are internally shared without restrictions. The pre-selection of the manager is just for convenience, not for compliance.Making copies could work, but honestly I don't...

  • 2 kudos
4 More Replies
lennox1
by New Contributor II
  • 1541 Views
  • 2 replies
  • 4 kudos

Databricks AI/BI Dashboard cross-filtering across different dataset

Hello Everyone,I recently started using AI/BI dashboard and I'm finding it difficult to cross-filter two visuals from two different dataset. Visual 1 displays Sales by region (month to date) sourced from dataset 1 and Visual 2 displays Open orders by...

  • 1541 Views
  • 2 replies
  • 4 kudos
Latest Reply
JoeMo
New Contributor II
  • 4 kudos

We are finding the same issue that you cannot cross filter on multiple datasets.  This would be an incredibly useful feature. Our scenario is we have a trip with a set of deliveries.  We want to find inefficient trips based on trip level KPIs and the...

  • 4 kudos
1 More Replies
JstelaBR
by Databricks Partner
  • 545 Views
  • 0 replies
  • 1 kudos

Databricks Free Edition + $100M in Skills: why this matters

Databricks launching a Free Edition and committing $100M to data + AI education isn’t just about free access — it’s about changing how people learn data engineering.When engineers learn on a unified platform, not a stitched-together toolchain, they s...

  • 545 Views
  • 0 replies
  • 1 kudos
Ties
by New Contributor II
  • 830 Views
  • 5 replies
  • 1 kudos

Resolved! Query does finish on serverless but will not on classic

Dear community,We are running nightly businessvaults. Last year it stopped to finish on classic wh and after testing until completion when switching to serverless wh it stayed that way but costs have increased a lot. I have been testing numerous spar...

Ties_0-1767884888474.png
  • 830 Views
  • 5 replies
  • 1 kudos
Latest Reply
Ties
New Contributor II
  • 1 kudos

I saw that in this topic a reply was selected as a solution. Sadly this is not the case and we are still in limbo with this issue. I tried setting up a meeting through support for databricks on azure but the third party rep microsoft provided did not...

  • 1 kudos
4 More Replies
data-wrangler
by New Contributor II
  • 2458 Views
  • 4 replies
  • 0 kudos

Foreign Catalog with BigQuery connects, but appears empty, and queries fail

Hi -- I'm trying to connect to BigQuery as a foreign catalog. I'm able to create and successfully test the connection, but when I create a foreign catalog it appears empty, and queries against that catalog return a "TABLE_OR_VIEW_NOT_FOUND" error.The...

  • 2458 Views
  • 4 replies
  • 0 kudos
Latest Reply
lorenz_singer
New Contributor II
  • 0 kudos

Hello, I had the same problem (foreign catalog for BigQuery project with limited access) and was able to solve it with the SQL command "REFRESH FOREIGN CATALOG catalog_name". It took a while, but after it finished with "OK", all BigQuery tables could...

  • 0 kudos
3 More Replies
cristianc
by Contributor
  • 2682 Views
  • 3 replies
  • 1 kudos

How does the refresh work for AI/BI (formerly LakeView Dashboards)

Greetings,I'm writing this message because I want to understand how does the "automatic refresh" feature work for AI/BI dashboards that use SQL Serverless endpoints?I'm asking because sometimes the published dashboard refreshes when viewing the link ...

  • 2682 Views
  • 3 replies
  • 1 kudos
Latest Reply
gyorgyjelinek
New Contributor III
  • 1 kudos

I have the same impression. But I guess besides the parameters time related functions (or any?) included in the source SQL must trigger the refresh. Can this behaviour be switched off somehow? Using a cached version?

  • 1 kudos
2 More Replies
hobrob_ex
by New Contributor III
  • 542 Views
  • 2 replies
  • 1 kudos

Resolved! Anchor links in notebook markdown

Does anyone know if there is a way to get anchor links working in Databricks notebooks so you can jump to sections in the same book without a full page refresh? i.e. something that works like the following html:<a href="#jump_to_target">Jump</a>...<p...

  • 542 Views
  • 2 replies
  • 1 kudos
Latest Reply
iyashk-DB
Databricks Employee
  • 1 kudos

@hobrob_ex , yes, this is possible, but not like the HTML way; instead, you will have to use the markdown rendering formats. Add #Heading 1, #Heading 2.. so on in the (+Text) button of the notebook. Once these headings/ sections that you want are con...

  • 1 kudos
1 More Replies
Stanciu_Cristi
by New Contributor III
  • 582 Views
  • 2 replies
  • 3 kudos

Resolved! Dynamic Global Filters

Hi everyone, I hope you're all doing well! I'm currently working on an AI/BI dashboard designed for business users, where the goal is for users to simply view and interact with the data in the dashboard. I've asked this question before to the Agent a...

  • 582 Views
  • 2 replies
  • 3 kudos
Latest Reply
davidmorton
Databricks Employee
  • 3 kudos

Ultimately, your ask is essentially what happens when you're creating a new dashboard and you select some filter fields from the right side. The challenge here, however, is that you want this to be available to the user, and not simply at creation ti...

  • 3 kudos
1 More Replies