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
  • 3039 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
  • 3039 Views
  • 0 replies
  • 0 kudos
meghana_tulla
by New Contributor III
  • 572 Views
  • 1 replies
  • 0 kudos

Issue with UCX Dashboard Display on Databricks v0.5.7 Installation

Hi,I am trying to install UCX for Databricks workspace using the Databricks CLI. When I attempt to install a specific older version instead of the latest, I get a dashboard creation error. This seems to be due to the April 7 update, which removed the...

  • 572 Views
  • 1 replies
  • 0 kudos
Latest Reply
Advika
Databricks Employee
  • 0 kudos

Hello @meghana_tulla! Older versions of UCX may fail to install because they try to create legacy dashboards, which are no longer supported following the April 7 update. To work around this, make sure your Databricks environment is aligned with the l...

  • 0 kudos
ahid
by New Contributor
  • 1145 Views
  • 2 replies
  • 0 kudos

Databricks Connector for Looker Studio – No Aggregation Pushdown + 1M Row Limit

Hi Databricks Community,I'm trying to understand which team is responsible for maintaining the Databricks Connector for Looker Studio . We’re currently facing a major performance bottleneck with how this connector operates.Specifically:The connector ...

  • 1145 Views
  • 2 replies
  • 0 kudos
Latest Reply
AndreyMirskiy
Databricks Employee
  • 0 kudos

Thank you for the feedback! Unfortunately there is a limitation in Looker Studio Community Connector API. getData method does not specify aggregation expectations for the data source. Therefore, a connector is expected to retrieve non-aggregated resu...

  • 0 kudos
1 More Replies
iamgoce
by New Contributor III
  • 2243 Views
  • 4 replies
  • 2 kudos

Resolved! Using Parameters in EXECUTE IMMEDIATE on Databricks SQL 2025.15 not working

Hi everyone,We are having an issue using parameters with EXECUTE IMMEDIATE statements, when running on SQL serverless running DBSQL v2025.15 (currently in preview channel):declare or replace var query = "SELECT :PARAMETER_1"; EXECUTE IMMEDIATE query;...

iamgoce_0-1744379589689.png iamgoce_0-1744379939492.png
  • 2243 Views
  • 4 replies
  • 2 kudos
Latest Reply
iamgoce
New Contributor III
  • 2 kudos

@Louis_Frolio thanks for the detailed explanation, that makes more sense.

  • 2 kudos
3 More Replies
Vasu_Kumar_T
by New Contributor II
  • 578 Views
  • 1 replies
  • 0 kudos

Blade bridge products Availability

Hello All,I wanted to touch base regarding the training and tool for Bladebridge Analyzer that we currently have access to. This has been quite useful in understanding and showcasing its capabilities to our customers.However, as we move forward, we a...

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

Hi @Vasu_Kumar_T, Did you try the course mentioned on this page: https://www.databricks.com/blog/welcoming-bladebridge-databricks-accelerating-data-warehouse-migrations-lakehouseIf you are a Databricks partner, you can access BladeBridge migration tr...

  • 0 kudos
Akshay_Petkar
by Valued Contributor
  • 2321 Views
  • 10 replies
  • 7 kudos

How to Complete CDW Migration Best Practices Training Labs on Databricks Learning Portal?

I am going through the labs for the CDW Migration Best Practices training on the Databricks Learning Portal and scored 75%. However, it still shows as "In Progress."Can anyone explain the criteria for marking the labs as complete? Do I need a higher ...

  • 2321 Views
  • 10 replies
  • 7 kudos
Latest Reply
betterahyosi2k2
New Contributor II
  • 7 kudos

Hello,I'm trying to finish Delivery Specialization: CDW Migration Best Practices course but I could able to achieve only 50%.could you please share those answer notebooks to this email "betterahyosi2k20@gmail.com" ???

  • 7 kudos
9 More Replies
Paddy_chu
by New Contributor III
  • 1421 Views
  • 5 replies
  • 1 kudos

Does anyone knows how to create Pareto plot on databricks lakeview dashboard?

Hi,Does anyone knows how to create Pareto plot on databricks lakeview dashboard? My stakeholder would really like to see this display on the dashboard. I'm able to get the values on a bar chart and create a cumulative percentage variable, but when I'...

  • 1421 Views
  • 5 replies
  • 1 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 1 kudos

I do not have any handy.  A bit of research on your part might get you what you need.  Also, the recommendations to embed in Lakeview refers to embedding a static image of your chart in Lakeview dashboards.  You cannot integrate third party tools in ...

  • 1 kudos
4 More Replies
thales_campolim
by New Contributor II
  • 1227 Views
  • 3 replies
  • 1 kudos

How to collapse class' methods by default?

I have built a class which is already over 2.5k code lines.It is extremelly painfull have to scroll a lot once you need something you know it on the bottom. I have looked after a solution to set the collapse as a default but could not find.Has anyone...

  • 1227 Views
  • 3 replies
  • 1 kudos
Latest Reply
SP_6721
Honored Contributor
  • 1 kudos

Hi @thales_campolim Just to clarify, are you referring to working in Databricks, or is this in another IDE or code editor?

  • 1 kudos
2 More Replies
koral
by New Contributor
  • 465 Views
  • 1 replies
  • 0 kudos

Unable to View Analytics – Admin Access Issue

Hi,I’m the admin of the account, but when I go to the Analytics section, I can’t see any data.Is there a way to fix this?Thanks!

  • 465 Views
  • 1 replies
  • 0 kudos
Latest Reply
Advika
Databricks Employee
  • 0 kudos

Hello @koral! It’s possible the missing data is due to the dataset being deleted or not properly loaded into the Catalog. Could you check if the dataset is still available and correctly linked? Also, make sure there aren’t any filters applied that co...

  • 0 kudos
koral
by New Contributor
  • 2565 Views
  • 0 replies
  • 0 kudos

Technical Issue with Databricks Marketplace Lead Notifications

Hi,We publish listings on the Databricks Marketplace.Several times a week, we receive a lead notification stating: "db sp has installed 'Etsy Dataset'."It’s always the same dataset and the same name, so it’s likely a technical error.Does anyone know ...

koral_0-1744190031248.png
  • 2565 Views
  • 0 replies
  • 0 kudos
MightyMasdo
by New Contributor III
  • 2406 Views
  • 6 replies
  • 2 kudos

writing into delta table using databricks connect

Hello we are currently facing a challenge with writing data from a local machine to Delta tables. While small data loads (e.g., 100 Rows) work without any issues, attempting to write larger batches (around 1,000 Rows) results in an exception. the iss...

  • 2406 Views
  • 6 replies
  • 2 kudos
Latest Reply
vr
Contributor III
  • 2 kudos

Code?

  • 2 kudos
5 More Replies
DataFarmer
by New Contributor II
  • 9112 Views
  • 6 replies
  • 1 kudos

Resolved! How to let Business Users edit tables in Databricks

Hi Community!I have the requirement that business users shall be able to edit/update tables in Unity Catalog, e.g. master data records, mapping tables. I also want thes actions to be logged for auditing/troubleshooting.Is there any simple solution to...

  • 9112 Views
  • 6 replies
  • 1 kudos
Latest Reply
Junpei_Liang
New Contributor II
  • 1 kudos

Just checking in to see if there are any new updates on this. 

  • 1 kudos
5 More Replies
Anton2
by New Contributor II
  • 2056 Views
  • 4 replies
  • 1 kudos

Recovering Lost Dashboard Data

Hello,I attempted to update the SQL warehouse ID for all our dashboards using the Databricks SDK lakeview.update method. However, I mistakenly passed a dashboard object without the serialized_dashboard value, which resulted in all our dashboards beco...

  • 2056 Views
  • 4 replies
  • 1 kudos
Latest Reply
LeviDane
New Contributor II
  • 1 kudos

I am facing the same.

  • 1 kudos
3 More Replies
jhrcek
by New Contributor III
  • 15082 Views
  • 16 replies
  • 8 kudos

Resolved! Misleading UNBOUND_SQL_PARAMETER even though parameter specified

Hello. Please forgive me if this is not the right place to ask, but I'm having issues with databricks' statement execution api. I'm developing Haskell client for this api.I managed to implement most of it, but I'm running into issues with using named...

  • 15082 Views
  • 16 replies
  • 8 kudos
Latest Reply
vivily
New Contributor II
  • 8 kudos

So far, the parameter works for me too if 1. it is fed by a widget or 2. when not mixing python and sql in the same notebook. It is still failing if the two are mixed in the same notebook. 

  • 8 kudos
15 More Replies
Pramod_G
by New Contributor II
  • 995 Views
  • 1 replies
  • 0 kudos

How can I retrieve the total count of requests processed by the SQL warehouse during a given period?

Hi,I need to create a dashboard displaying the total number of requests per status that have been processed or are currently being processed by the SQL warehouse.I noticed the default graph for the SQL warehouse shows the number of queries executed p...

Pramod_G_0-1743011703416.png
  • 995 Views
  • 1 replies
  • 0 kudos
Latest Reply
Shua42
Databricks Employee
  • 0 kudos

You can use the system table for this, system.query.history, which is now in public preview: https://docs.databricks.com/aws/en/admin/system-tables/query-history It contains the full query history for warehouses, including status, executer, query tex...

  • 0 kudos
jacobzeb
by New Contributor II
  • 3830 Views
  • 1 replies
  • 0 kudos

Vizro Dashboarding in Databricks

I am attempting to create a Vizro dashboard in a databricks notebook. I have validated that the code to generate dashboard works is accessible when running the notebook on my local machine. However, when attempting to compile the dashboard on a datab...

  • 3830 Views
  • 1 replies
  • 0 kudos
Latest Reply
jacobzeb
New Contributor II
  • 0 kudos

  • 0 kudos