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...
HiWe are in the process of designing and building new silver and gold layers (Star Schema). We will be using Databricks, which is new to the organisation.The silver layer will be modelled using classic 3NF, with SCD 7.The gold layer is a star schema....
Hi @RobTScot, This is a common design decision in lakehouse data modeling, and the right answer depends on the layer, the tooling, and the downstream consumers. Here is a breakdown of the key considerations. SILVER LAYER (3NF WITH SCD 7) For silver t...
Hi @Hubert-Dudek I am getting following error: METRIC_VIEW_WINDOW_FUNCTION_NOT _SUPPORTED The metric view is not allowed to use window function (...) With the following definition:- name: Sales net Total- expr: SUM(MEASURE(`Sales net`)) OVER())Howeve...
Hi @wrosa, The error you are seeing (METRIC_VIEW_WINDOW_FUNCTION_NOT_SUPPORTED) is expected behavior. Metric views do not allow raw SQL window functions like SUM(...) OVER() directly in a measure's expr definition. This is by design because metric vi...
Hi everyone!Just wanted to jump on here to see if anyone is having issues with Connecticut not mapping on their choropleth map? We had several we were using to map # of healthcare providers in the country but just noticed that Connecticut was no long...
Hi, This is a known issue that stems from Connecticut's 2022 county reorganization and how the AI/BI Dashboard choropleth map resolves FIPS codes. WHAT'S HAPPENING In June 2022, the US Census Bureau officially replaced Connecticut's 8 traditional cou...
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...
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...
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...
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...
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...
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.
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...
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
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...
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...
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...
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...
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!!
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
