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
  • 3592 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
  • 3592 Views
  • 0 replies
  • 0 kudos
amdata
by New Contributor
  • 632 Views
  • 1 replies
  • 1 kudos

Resolved! Is it possible to download tables in a databricks dashboard as CSV/Excel?

I do not see the option as mentioned in the documentation here: https://docs.databricks.com/aws/en/dashboards/#:~:text=Download%20results%E2%80%8B,final%20file%20download.Please let me know if PNG is the only available option currently?

  • 632 Views
  • 1 replies
  • 1 kudos
Latest Reply
szymon_dybczak
Esteemed Contributor III
  • 1 kudos

Hi @amdata ,It was possible until recently  There's a bug and databricks team is working on a fix. So soon they should release a fix and then you will be able to export to csv as stated in documentation. Check below thread for more info:ONLY PNG form...

  • 1 kudos
taegyun
by New Contributor II
  • 709 Views
  • 3 replies
  • 3 kudos

Resolved! How to download widget(in canvas) result into CSV

The CSV download option has disappeared from the dashboard canvas, and only the PNG download option remains. The SQL download option is still active.Why did the previously available option disappear?When I select 'View Dataset,' the result I see is t...

  • 709 Views
  • 3 replies
  • 3 kudos
Latest Reply
szymon_dybczak
Esteemed Contributor III
  • 3 kudos

Hi @taegyun , @random_user77 It seems that this is a bug. This is a known issue, and the team is working on a fix. Check below thread:ONLY PNG format is available for databricks dashbo... - Databricks Community - 140902

  • 3 kudos
2 More Replies
Coffee77
by Honored Contributor II
  • 940 Views
  • 3 replies
  • 0 kudos

How to inject non-literal values in "table_changes" CDF function?

Hi guys,I am trying to use table_changes CDF function in an external SQL function run it from an SQL Warehouse serverless cluster in order to retrieve a set of changes from a given table. Here is the documentation for this fuunction:https://docs.data...

  • 940 Views
  • 3 replies
  • 0 kudos
Latest Reply
iamgoce
New Contributor III
  • 0 kudos

What's worked for us is to use a string variable to construct the query and then use EXECUTE IMMEDIATE to execute the query:DECLARE OR REPLACE VAR QUERY; SET VAR QUERY = 'SELECT * FROM TABLE_CHANGES("catalog.schema.table", "' || timestamp_start || '"...

  • 0 kudos
2 More Replies
boopa45
by Databricks Partner
  • 1078 Views
  • 5 replies
  • 2 kudos

databricks dashboards - how do share the dashboard to user with Limit the data access

how do share the dashboard to user with Limit the data access without create a new dashboard with filler in source qry?is there any other way?example,I have a dashboard it contains 3 location data exampleIndia CanadaUSA I need to give limited acces t...

  • 1078 Views
  • 5 replies
  • 2 kudos
Latest Reply
boopa45
Databricks Partner
  • 2 kudos

this is source query level right? what if user has only view access?

  • 2 kudos
4 More Replies
boopa45
by Databricks Partner
  • 825 Views
  • 3 replies
  • 0 kudos

how do share the dashboard to user with Limit the data access

how do share the dashboard to user with Limit the data access without create a new dashboard with filler in source qry?is there any other way?example,I have a dashboard it contains 3 location data exampleIndia CanadaUSAI need to give limited acces to...

  • 825 Views
  • 3 replies
  • 0 kudos
Latest Reply
boopa45
Databricks Partner
  • 0 kudos

this is source query level right? what if user has only view access? 

  • 0 kudos
2 More Replies
SFDataEng
by Contributor
  • 805 Views
  • 4 replies
  • 3 kudos

Please show seconds in date picker dashboard filter widget

Request: please adjust Databricks AI/BI Dashboard Filter Date Picker built-in style (font size, layout, etc.) so that the full datetime selected for "from" and "to" times are displayed (including all minutes and seconds digits) Why: it is frustrating...

Dashboard datetime picker obscures minute and second fields, 2025-11-13_19.03UTC.png Hacky fix fopr Dashboard datetime picker to show minute and second fields, 2025-11-13_19.03UTC.png Apache Sperset Dashboard datetime picker shows full minute and second fields, 2025-11-13_19.09UTC.png
Warehousing & Analytics
dashboard
date picker
filter
  • 805 Views
  • 4 replies
  • 3 kudos
Latest Reply
SFDataEng
Contributor
  • 3 kudos

Hi @stbjelcevic, thank you so much for tracking the request.  If it gets implemented, I will be able to Accept as Solution here.

  • 3 kudos
3 More Replies
Akshay_Petkar
by Valued Contributor
  • 7066 Views
  • 10 replies
  • 4 kudos

Resolved! How to Display Top Categories in Databricks AI/BI Dashboard?

In a Databricks AI/BI dashboard, I have a field with multiple categories (e.g., district-wise sales with 50 districts). How can I display only the top few categories (like the top 10) based on a specific metric such as sales?

  • 7066 Views
  • 10 replies
  • 4 kudos
Latest Reply
GunaR
New Contributor III
  • 4 kudos

This feature is released under the Oct-2025 round-up. Refer the Topic: "Dashboards Top/Bottom N Bar Chart Categories"https://www.databricks.com/blog/whats-new-aibi-october-2025-roundup

  • 4 kudos
9 More Replies
palearnings
by New Contributor III
  • 1194 Views
  • 7 replies
  • 0 kudos

Custom Catalog Not Visible to ADF and Looker in Databricks

Hi Databricks community,I’ve created a catalog called azure_data_factory and a database called studytube_azure_mysql_production. Within that database, I have three tables: academies, academy_naming_settings, and users.See the left side of the screens...

  • 1194 Views
  • 7 replies
  • 0 kudos
Latest Reply
palearnings
New Contributor III
  • 0 kudos

Hi @szymon_dybczak  and @Raman_Unifeye ,Thanks for answering my questions. I have granted the same permissions for both catalogues:USE CATALOGUSE SCHEMA on the schemas under both cataloguesSELECT on the tables under both schemas and cataloguesI even ...

  • 0 kudos
6 More Replies
luksquaresma
by New Contributor II
  • 1060 Views
  • 2 replies
  • 2 kudos

Dynamic populated multiple choice query parameters - Documentation clarification

Dear colleagues,I'm in need of finishing a dashboard with the new databricks dashboard structure, released somewhat recently. On it, I'll have some calculations which need to be percentages over certain partitions, such as `input_amount_percentage_pe...

  • 1060 Views
  • 2 replies
  • 2 kudos
Latest Reply
mark_ott
Databricks Employee
  • 2 kudos

It is possible to create dynamic parameter lists in Databricks dashboards—so, yes, the documentation is correct, but the crucial detail is that not all data sources or query environments support this feature in the exact same way, and certain limitat...

  • 2 kudos
1 More Replies
p_a_l
by New Contributor II
  • 849 Views
  • 2 replies
  • 4 kudos

Resolved! Failed to Access Azure Storage Container from Databricks in ADF Pipeline

 Hi Databricks community,I'm new to Databricks and I'm trying to connect Databricks to Azure MySQL using Azure Data Factory.When I run the pipeline, I get the following error: ErrorCode=AzureDatabricksCommandError, Hit an error when running the comma...

  • 849 Views
  • 2 replies
  • 4 kudos
Latest Reply
Coffee77
Honored Contributor II
  • 4 kudos

Could you provide more details about high level flow or design you are planning? Not understanding completely but you can take a look here how to connect ADF with Databricks via PATs -> https://www.sqlshack.com/integrating-azure-databricks-with-azure...

  • 4 kudos
1 More Replies
mtreigelman
by New Contributor III
  • 5793 Views
  • 6 replies
  • 6 kudos

Re-Using Datasets inside the Same SQL Dashboard

Hi folks, I am creating a SQL dashboard and want to know if I can re-use datasets within the same dashboard. The screenshot below captures what I would like to do pretty well, but to summarize... I need to run an computationally expensive query and w...

databricks_dash_dataset_recycle_question.png
  • 5793 Views
  • 6 replies
  • 6 kudos
Latest Reply
SFDataEng
Contributor
  • 6 kudos

AgreementYes, a feature to support nested datasets in Databricks AI/BI dashboards would seem convenient, e.g. as in both examples in the OP's screenshot.Specific needA use case that comes to mind would be to avoid the maintenance of parallel code acr...

  • 6 kudos
5 More Replies
AndreasFuchs
by New Contributor
  • 4945 Views
  • 1 replies
  • 0 kudos

Cost Tracing by accessed unity catalog catalog schema, sharing of sql warehouse

Hi community,we have several databricks workspaces per different teams and in each workspace several use case covered.How can we trace the costs per individual use cost for SQL Warehosue / serverless in case we use one SQL warehouse per workspace to ...

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

You have two related questions on Databricks SQL Warehouse (serverless) cost attribution and resource sharing across workspaces. Here’s a clear answer based on current Databricks capabilities and industry practice. Tracing Costs per Use Case (SQL War...

  • 0 kudos
carlaoftw
by New Contributor II
  • 2487 Views
  • 5 replies
  • 1 kudos

Resolved! Can not create a Streamlit Databricks App on free tier

I'm trying to deploy a minimal Streamlit app as a Databricks App on a fresh Free/Community workspace and I get:"Compute error - App creation failed unexpectedly. Please remediate by deleting the app."As alternatives, I also tried the API and the CLI ...

  • 2487 Views
  • 5 replies
  • 1 kudos
Latest Reply
eebruno
New Contributor II
  • 1 kudos

Good morning, everyone.The app is working again. I've already tested it and it's working.

  • 1 kudos
4 More Replies
arindamchoudhur
by New Contributor III
  • 938 Views
  • 5 replies
  • 1 kudos

Resolved! Help with visualization: view only top 10

Hi,I want to create a visualization where i want to show top 10 playerName with most sum of counter by dayDate. I reached till here. But i don't know how to limit top 10 playerName.Any help will be highly appreciated.

2025-11-07_14-07.png
  • 938 Views
  • 5 replies
  • 1 kudos
Latest Reply
arindamchoudhur
New Contributor III
  • 1 kudos

Finally what i did is:create a new data source with is query:WITH daily_totals AS (SELECTevent_date,playerName,SUM(counter) AS total_counterFROM your_tableGROUP BY event_date, playerName),ranked AS (SELECTevent_date,playerName,total_counter,ROW_NUMBE...

  • 1 kudos
4 More Replies
hch_fiq
by New Contributor II
  • 1214 Views
  • 3 replies
  • 1 kudos

Resolved! Free account: Genie API isn't working

Hi, I've created a service principal and setup OAuth - I can successfully call REST APIs to see workspace details. But, when I try to list the genie spaces in a workspace, I get {} as the result. In the UI, I can see two genie spaces I've created. An...

  • 1214 Views
  • 3 replies
  • 1 kudos
Latest Reply
szymon_dybczak
Esteemed Contributor III
  • 1 kudos

Hi @hch_fiq ,You need setup proper permissions for your service account to see genie space. Look at below Genie space ACL table from documentation. When there's no ACL set you won't see anynting. So, your Service Principal needs at least CAN VIEW/CAN...

  • 1 kudos
2 More Replies