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
  • 3484 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
  • 3484 Views
  • 0 replies
  • 0 kudos
DM3910
by Databricks Partner
  • 1506 Views
  • 1 replies
  • 1 kudos

How to Replicate unity catalog and workspaces from region to another in databricks

I have the need to replicate existing unity catalog and workspaces from one region to another in databricks. Need help in understanding the different ways in which it can be done

  • 1506 Views
  • 1 replies
  • 1 kudos
Latest Reply
TheOC
Databricks Partner
  • 1 kudos

Hey @DM3910 ,It may not be exactly what you need but there is some information in this article around cross-region/platform sharing:https://docs.databricks.com/aws/en/data-governance/unity-catalog/best-practices#cross-region-and-cross-platform-sharin...

  • 1 kudos
Shivla
by Databricks Partner
  • 541 Views
  • 1 replies
  • 0 kudos

Issues with Importing Visuals From SQL Editor to Dashbaord

Hello,I'm fairly new to databricks, and wanted to play around with creating dashboards similar to ones I've done in Tableau. With the genie being limited at times in graphs it can create, I used the SQL editor to get what I wanted; however, I'm havin...

Screenshot 2025-07-09 at 10.55.49 AM.png Screenshot 2025-07-09 at 10.55.29 AM.png
  • 541 Views
  • 1 replies
  • 0 kudos
Latest Reply
Advika
Community Manager
  • 0 kudos

Hello @Shivla! This issue might be related to how the region fields are configured in the choropleth map. If the same State column is assigned to both the Country and State/Province fields, the map may not load properly. Try assigning the state colum...

  • 0 kudos
Amit-Kumar
by Databricks Partner
  • 1350 Views
  • 2 replies
  • 4 kudos

Embed AI/BI dashboard on a website asks for login

It is disappointing to see that Databricks is quite at a premature stage and has just marketed the product, but the features are not ready to use yet.Our requirement is fairly straightforward: to create an AI/BI dashboard in Databricks, publish and e...

  • 1350 Views
  • 2 replies
  • 4 kudos
Latest Reply
Sharanya13
Contributor III
  • 4 kudos

Hi @Amit-Kumar Have you considered consumer access? If your users are internal users, you can onboard them as workspace users and provision a read-only access to dashboards and Genie. Alternatively, you could use embedded credentials approach for acc...

  • 4 kudos
1 More Replies
rakeshsekar2025
by New Contributor III
  • 1264 Views
  • 4 replies
  • 1 kudos

Azure Databrick Dashboards selection does not work even though data filter selection is visible

The data selection is part of loaded data if I want to filter out the data I'm not able to filter it out I believe this is glitch in the data bricks dashboard UI 

Untitled.png
  • 1264 Views
  • 4 replies
  • 1 kudos
Latest Reply
rakeshsekar2025
New Contributor III
  • 1 kudos

This is parameter input to the databricks sql query 

  • 1 kudos
3 More Replies
data-grassroots
by New Contributor III
  • 1554 Views
  • 1 replies
  • 1 kudos

Python UDTF

Attempting to create a Python UDF and receiving an error stating it's not supported in my environment.running on SQL Serverless Cluster - Preview (v 2025.16)[FEATURE UNAVAILABLE]Python UDTF is not supported in your environment. To use this feature, p...

  • 1554 Views
  • 1 replies
  • 1 kudos
Latest Reply
nayan_wylde
Esteemed Contributor II
  • 1 kudos

Currently Serverless supports only scaler valued function not table valued function. also you need to provide the catalog and schema in the function.You can create using a pro computecreate function {catalog_name}.{schema_name}._rrr_taxonomy_test()RE...

  • 1 kudos
Malthe
by Valued Contributor II
  • 852 Views
  • 2 replies
  • 0 kudos

Online Table pricing for infrequent use

According to the pricing page, the minimum cost in using this product is 1 DBU per hour.Often times, access to such tables comes in bursts with many periods of idle time. How is infrequent use factored into the pricing? This is also important for set...

  • 852 Views
  • 2 replies
  • 0 kudos
Latest Reply
Malthe
Valued Contributor II
  • 0 kudos

As far as I can tell, the minimum charge for an online table is DBU-cost x 24 x 30 per month, i.e. around $720 per month.Is the 15-minute scale-down window documented somewhere?With a 15-minute scale-down window, assuming just one access per hour, th...

  • 0 kudos
1 More Replies
kevin11
by Valued Contributor
  • 982 Views
  • 1 replies
  • 2 kudos

Genie room not in lineage

Hello,We recently modified some table names and used the UC Lineage to identify the users that were accessing these particular tables to notify. However, it seems we broke our Genie Space that was using that table. As best as I can tell, queries from...

  • 982 Views
  • 1 replies
  • 2 kudos
Latest Reply
saurabh18cs
Honored Contributor III
  • 2 kudos

As of now, system tables like information_schema.table_usage or query_history do not log Genie Space queries. They primarily log interactive and scheduled queries from notebooks, dashboards, and the SQL editor.you will need to rely on Genie configura...

  • 2 kudos
julianner
by New Contributor II
  • 1332 Views
  • 2 replies
  • 0 kudos

Internal Error During Spark SQL Phase Optimization – Possible Bug in Spark/Databricks Runtime

Bug SummaryTitle: Spark SQL internal error when executing SQL code in the Azure Databricks SQL Editor  DescriptionWhen executing SQL code in the Azure Databricks SQL Editor, a Spark SQL internal error is returned.  Steps to ReproduceCopy and paste th...

julianner_0-1750662110562.png
  • 1332 Views
  • 2 replies
  • 0 kudos
Latest Reply
saurabh18cs
Honored Contributor III
  • 0 kudos

Check Databricks runtime version:If possible, upgrade to the latest Databricks runtime, as internal errors are sometimes fixed in newer versions.

  • 0 kudos
1 More Replies
jakobhaggstrom
by New Contributor
  • 6550 Views
  • 3 replies
  • 0 kudos

Issue when using M2M authentication with azure databricks jdbc driver 2.7.1

Hi!I try to connect to an azure databricks sql warehouse in dbeaver, which uses the azure databricks jdbc driver version 2.7.1 ## and I cannot get M2M authentication to work. I get a 'Not Authorized' (401) response when I try to connect, and it seems...

  • 6550 Views
  • 3 replies
  • 0 kudos
Latest Reply
gdo
New Contributor II
  • 0 kudos

Hey @jakobhaggstrom,It's possible to connect to DBX using an Azure service principal. You're just missing the OIDC URL in the JDBC driver's parameters.The OIDC discovery is enabled by default but you need to set its URL which contains your Azure tena...

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

Databrick AI/BI Dashboard cross-filtering on the map glitch

Hi everyone,I recently started using AI/BI dashboard and I'm struggling with this glitch in the map. The visual was generated without any issues but the cross-filtering of the map for example, if I click on a county, the rest of the chart values chan...

Screenshot 2025-06-13 135856.png Screenshot 2025-06-13 135812.png Screenshot 2025-06-13 135843.png
  • 2440 Views
  • 2 replies
  • 2 kudos
Latest Reply
HariSankar
Contributor III
  • 2 kudos

Hey @meljung ,The issue seems to stem from using an aggregated metric (`count_distinct(user_id)`) in the map visual.When clicking on a county, the map attempts to filter other visuals using the underlying dimension, but inconsistencies may occur if t...

  • 2 kudos
1 More Replies
Shun_T
by Databricks Partner
  • 1653 Views
  • 1 replies
  • 0 kudos

Error about creating a dashboard with Asset Bundles

Hi, I'm Shun from Japan.I tried to create Databricks Dashboard using Asset Bundles.But, I got an error message bellow on Web Terminal.$ databricks bundle deployWarn: Failed to load git info from /api/2.0/workspace/get-statusError: failed to get dashb...

  • 1653 Views
  • 1 replies
  • 0 kudos
Latest Reply
HariSankar
Contributor III
  • 0 kudos

Hi @Shun_T ,The error message you're seeing,usually means that the dashboard you're trying to deploy either doesn’t exist in your Databricks workspace,or the ID/reference used in the YAML file is invalid.Here are a few steps that should help:1.Verify...

  • 0 kudos
source2sea
by Contributor
  • 1350 Views
  • 1 replies
  • 0 kudos

where can i change the dashboard inherited permission

 I do no like the fact that 'all workspace users' can manage' the dashboard 

source2sea_0-1749571713608.png
  • 1350 Views
  • 1 replies
  • 0 kudos
Latest Reply
HariSankar
Contributor III
  • 0 kudos

Hey @source2sea ,I ran into the same issue before. The reason it shows "All workspace users – Can Manage (inherited)" is because the permission is coming from the folder where your dashboard is saved.To fix it, go to that folder, click on the three d...

  • 0 kudos
jackintosh
by Databricks Partner
  • 4594 Views
  • 2 replies
  • 0 kudos

Dynamic GRANT

Hello,I am struggling trying to assign permission dynamically on a schema. I am using databricks asset bundle and I have a parametrized script to assign permission.grant select on schema {{schema}} to {{group}};I cannot achieve a dynamic grant statem...

  • 4594 Views
  • 2 replies
  • 0 kudos
Latest Reply
jameshughes
Databricks Partner
  • 0 kudos

I use notebooks as part of the asset bundle deployment to conduct a lot of dynamic configurations based upon the workspace being deployed to (ex. Development, Test, Production).  In conjunction, I developed a helper Python library with a number of fu...

  • 0 kudos
1 More Replies
josh__
by New Contributor II
  • 1097 Views
  • 1 replies
  • 0 kudos

Databricks Free Edition + dbt cloud

Is it possible it use Databricks Free Edition + dbt cloud for dbt projects?

  • 1097 Views
  • 1 replies
  • 0 kudos
Latest Reply
Renu_
Valued Contributor II
  • 0 kudos

Hi @josh__, I guess yes, you can use Databricks Free Edition with dbt Cloud for dbt projects. Just keep in mind that the Free Edition is mainly meant for learning and experimentation, so it does have some limitations around features and resources. Mi...

  • 0 kudos
ArturSvoboda
by New Contributor
  • 848 Views
  • 1 replies
  • 0 kudos

Join altered view tables

Hi! I have these two tables which are altered(renamed) views from my main table, and there seems to be no way of joining this tables. Everytime I try Databricks indicates that these tables cannot be found, but if I go and write a Select * statements ...

  • 848 Views
  • 1 replies
  • 0 kudos
Latest Reply
lingareddy_Alva
Esteemed Contributor
  • 0 kudos

Hi @ArturSvoboda This sounds like a classic Databricks workspace isolation issue. Here are the most likely causes and things to check:1. Temporary Views vs Persistent ViewsYour renamed views might be temporary views that only exist in your current Sp...

  • 0 kudos