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
  • 3157 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
  • 3157 Views
  • 0 replies
  • 0 kudos
QueryingQuagga
by New Contributor III
  • 4053 Views
  • 2 replies
  • 1 kudos

Databricks SQL editor - we can get a long way with a few Quality of Life improvements

Hello all (and, if you are watching these posts, Databricks employees/representatives ),I hope you take this idea into account - I haven't been able to find a place where one can vote on features, but I believe that this idea would make very real im...

  • 4053 Views
  • 2 replies
  • 1 kudos
Latest Reply
stbjelcevic
Databricks Employee
  • 1 kudos

Hi @QueryingQuagga , We always appreciate feature requests! If you are working with an account team, you can always pass this information along to them, they have the ability to submit feature requests and vote on existing feature requests as well. I...

  • 1 kudos
1 More Replies
jacobzeb
by New Contributor II
  • 4192 Views
  • 2 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...

  • 4192 Views
  • 2 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

This issue is common when attempting to run interactive dashboards (such as Vizro or Plotly Dash) within Databricks notebooks; many users face the "This site can't be reached" message because the dashboard tries to launch a local web server on an add...

  • 0 kudos
1 More Replies
neesam
by New Contributor II
  • 233 Views
  • 3 replies
  • 0 kudos

Can't run SQL on my cluster

I'm relatively new to Databricks and Spark and have decided to create a Spark cluster with AWS under the free 14 day trial.The JSON to the cluster is as follows:{"data_security_mode": "DATA_SECURITY_MODE_DEDICATED","single_user_name": "me@gmail.com",...

  • 233 Views
  • 3 replies
  • 0 kudos
Latest Reply
KaushalVachhani
Databricks Employee
  • 0 kudos

Hi @neesam, while the command is hanging, check the driver logs from the cluster page to see if they provide any clues about what might be causing this issue. 

  • 0 kudos
2 More Replies
PabloCSD
by Valued Contributor II
  • 4037 Views
  • 1 replies
  • 0 kudos

Can't access to a directory for installing .whl

I was trying to install a personalized .whl file located in the "shared" folder but I'm obtaining this error:org.apache.spark.SparkException: Process List(/bin/su, libraries, -c, bash /local_disk0/.ephemeral_nfs/cluster_libraries/python/python_start_...

Warehousing & Analytics
dbx
library installation
  • 4037 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

The error indicates a permissions issue when trying to install your custom .whl file from the "Shared" folder in Databricks using dbx and Spark. Specifically, the error [Errno 1] Operation not permitted suggests the process does not have the required...

  • 0 kudos
nirquant
by New Contributor
  • 3737 Views
  • 1 replies
  • 0 kudos

VS Code Extension Sync Destination Changed Unexpectedly

I recently updated my Databricks VS Code extension from version 1.4.0 to 2.4.0. After the update, I noticed that:The "Configure Sync Destination" button is missing.The sync destination format has changed to a remote folder instead of the previous set...

  • 3737 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

The upgrade to Databricks VS Code extension v2.4.0 changed the sync destination system from the previous workspace directory setup, removing the "Configure Sync Destination" button and setting the default to a more rigid remote folder structure (comm...

  • 0 kudos
koral
by New Contributor
  • 2884 Views
  • 1 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
  • 2884 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

Yes, this is a known issue reported by other Databricks Marketplace publishers: receiving frequent lead notifications stating "db sp has installed 'Etsy Dataset'" for the same dataset and name, which suggests an underlying technical error in the lead...

  • 0 kudos
bobmclaren
by New Contributor II
  • 3837 Views
  • 1 replies
  • 0 kudos

Comparing Methods for Scheduling Streaming updates via dbt

We are trying to schedule updates to streaming tables and materialized views in Azure Databricks that we have defined in dbt.Two options we are considering are `SCHEDULE CRON` and just scheduling `dbt run` commands via CI/CD. The `SCHEDULE CRON` opti...

  • 3837 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

Your understanding of the trade-offs between using SCHEDULE CRON on streaming tables/materialized views and the dbt run orchestration in Azure Databricks is largely correct, and you’ve identified the two main pain points: orchestration of dependencie...

  • 0 kudos
Ajbi
by New Contributor II
  • 2961 Views
  • 1 replies
  • 0 kudos

Power BI refresh from Databricks workflow

We recently enabled the preview feature to refresh power bi datasets from data bricks workflow, but when we run the job data changes aren't being applied despite a completed status in refresh history. Could anyone clarify whether this is intended pre...

Warehousing & Analytics
Databricks Power BI Task
power bi refresh
  • 2961 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

This is a known issue with the Power BI/Databricks integration preview for refreshing Power BI datasets from Databricks workflows. Even when a job completes and the refresh history shows success, actual data changes—such as newly inserted rows—are of...

  • 0 kudos
ZoraidaHS
by New Contributor
  • 3380 Views
  • 1 replies
  • 0 kudos

Disjunction on static filters for a Widget

I would like to be able to express something like: WHERE columnA = "valueA" OR columnB = "valueB" but on the Widget. I only see the possibility that chaining filters that are processed as AND operator. Am I missing something?

  • 3380 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

Most widget filter interfaces only support multiple filters using an AND operator, meaning each condition must be true for a row to be included. If you want to use an OR operator, such as filtering where columnA = "valueA" OR columnB = "valueB", most...

  • 0 kudos
JZhang
by New Contributor
  • 3371 Views
  • 1 replies
  • 0 kudos

Issues in visualizing tables when exporting dashboard to HTML

Hello communityI am facing an issue when I export a dashboard to an HTML: the problem is that the HTML has white background but the exported tables have black colors, like the example I am showing below Does someone know how to handle this visualizat...

JZhang_0-1740495725310.png
  • 3371 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

To resolve the issue of dashboard tables exporting to HTML with mismatched colors—specifically black table backgrounds against a white HTML page—review and adjust your dashboard’s CSS or formatting settings before export. The problem typically occurs...

  • 0 kudos
Aminsnh
by New Contributor
  • 4010 Views
  • 1 replies
  • 0 kudos

Adding customized shortcut keys

Hi all, I need to add a shortcut key for R's pip operator (%>%) to my Databricks notebook. I want the operator to be written in my code snippet when I hold down the shortcut keys (shift + ctrl + m). Is there a straightforward way to add such shortcut...

  • 4010 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

Databricks notebooks do not natively support defining custom keyboard shortcuts to insert specific code snippets like R’s pipe operator () within the notebook editor UI. The list of standard shortcuts available is limited to navigation, cell manageme...

  • 0 kudos
danilo_amorim
by New Contributor
  • 3425 Views
  • 1 replies
  • 0 kudos

Unable to connect to databricks with ODBC connection on a Mac

Hi all!Need help configuring ODBC connection on a Mac. I'm receiving the error "The web server failed to start, please verify if  port 8020 is being used by another connection or annother application".I've downloaded and installed Databricks ODBC con...

danilo_amorim_0-1742470647673.png
  • 3425 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

The error "The web server failed to start, please verify if port 8020 is being used by another connection or another application" when configuring an ODBC connection to Databricks on a Mac, even after checking that port 8020 is not in use, is a known...

  • 0 kudos
patilsuhasv
by New Contributor
  • 3357 Views
  • 2 replies
  • 0 kudos

Dela Table and history

Hi All,How can I maintain 7 years of transactional data in delta table? Can I have log retention of 7 days, but data retention of 7 years?Appreciate your response.Thanks and regards Suhas

  • 3357 Views
  • 2 replies
  • 0 kudos
Latest Reply
Isi
Honored Contributor III
  • 0 kudos

Hi @patilsuhasv,Maintaining 7 years of transactional data in a Delta Lake table is technically possible, but it requires careful configuration — and it’s important to understand the recent changes Databricks announced (effective December 2025) regard...

  • 0 kudos
1 More Replies
AndreasWagner
by New Contributor II
  • 6578 Views
  • 2 replies
  • 1 kudos

PowerBI connected to SAP Databricks

hi everyone, does somebody have experience with connecting PowerBI to SAP Databricks in the BDC? I have quite a few SAP customers interested in that ... many thanks, Andreas

  • 6578 Views
  • 2 replies
  • 1 kudos
Latest Reply
DanielFroehler
New Contributor II
  • 1 kudos

Hi @WiliamRosa ,do you know which feature is missing in SAP Databricks that it doesnt work? As Andreas said- everybody is asking that question.KR Daniel

  • 1 kudos
1 More Replies
CEH
by New Contributor II
  • 637 Views
  • 5 replies
  • 2 kudos

Union of tiny dataframes exhausts resource, memory error

As part of a function I create df1 and df2 and aim to stack them and output the results.  But the results do not display within the function, nor if I output the results and display after.results = df1.unionByName(df2, allowMissingColumns=False)displ...

  • 637 Views
  • 5 replies
  • 2 kudos
Latest Reply
Advika
Databricks Employee
  • 2 kudos

Hello @CEH! Did any of the suggestions above help resolve the issue?If so, please mark the most helpful reply as the accepted solution. Or, if you found another fix, please share it with the community so others can benefit as well.

  • 2 kudos
4 More Replies