cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Oliver_Angelil
by Valued Contributor II
  • 6926 Views
  • 3 replies
  • 3 kudos

New SQL Dashboard feature never loads

I've created the sample Taxi dashboard, but the charts never load?

Screenshot 2023-05-11 at 13.39.59
  • 6926 Views
  • 3 replies
  • 3 kudos
Latest Reply
jose_gonzalez
Moderator
  • 3 kudos

Do you have the full error stack trace? does this happens frequently? whats the size of your cluster?

  • 3 kudos
2 More Replies
jasperputs
by New Contributor III
  • 9208 Views
  • 5 replies
  • 0 kudos

Databricks SQL Dashboard refresh not updating

I am trying to create a SQL Dashboard on top of a streaming dataset (Delta format). I created multiple queries referencing the file on the datalake, not a hive table. With these queries I created multiple visualizations in a Databricks SQL Dashboard....

image.png image
  • 9208 Views
  • 5 replies
  • 0 kudos
Latest Reply
Anonymous
Not applicable
  • 0 kudos

@Jasper Puts​ :Here are some potential solutions or next steps you can try:Check the query refresh rate: Confirm that the queries are also set to refresh every minute or less. If the queries are not refreshing at the same rate as the dashboard, this ...

  • 0 kudos
4 More Replies
pawank9
by New Contributor II
  • 1698 Views
  • 2 replies
  • 0 kudos

SQL dashboard report: Select table column dynamically

I am using SQL Dashboard report, there are around 400 columns in a table, I want to display some of the columns based on data, not all 400 columns should be displayed.eg: a table have column named c1, c2,c3,c4 and rows r1, r2, r3, r4. The report shou...

  • 1698 Views
  • 2 replies
  • 0 kudos
Latest Reply
Hubert-Dudek
Esteemed Contributor III
  • 0 kudos

You can build own logic using query parameters, and/or just select required columns based on case.

  • 0 kudos
1 More Replies
vanessafvg
by New Contributor III
  • 2564 Views
  • 3 replies
  • 1 kudos

linking filters from different Databricks SQL queries in a Dashboard

I am having to use Databricks SQL dashboard for some analysis, it seems very clunky. If i have multiple queries, is it possible to apply the same filters to all the queries in the dashboard or do i have to duplicate the filters for each query in the ...

  • 2564 Views
  • 3 replies
  • 1 kudos
Latest Reply
FelixH
New Contributor II
  • 1 kudos

Same issue here. According the docs, using query filters with the same name and values should result in a single dashboard filter. However, filters are duplicated. I also tried using this setting but no success

  • 1 kudos
2 More Replies
ncouture
by Contributor
  • 1090 Views
  • 1 replies
  • 0 kudos

Resolved! How do you run a query as the owner but use a parameter as a viewer

I have a query that is hitting a table I have access too. Granting access to everyone is not an option. I am using this query in a SQL Dashboard. One of the where clause conditions uses a parameter populated by another query. I want this parameter qu...

  • 1090 Views
  • 1 replies
  • 0 kudos
Latest Reply
ncouture
Contributor
  • 0 kudos

It is not possible to do what I want. Somewhat seems like a security flaw but what ever

  • 0 kudos
Meenu1
by New Contributor II
  • 665 Views
  • 0 replies
  • 1 kudos

X axis range for visualization in sql dashboard

Unable to set x axis range for charts in sql dashboard. The automatic range and padding that is set doesn't match across all plot types. For line charts with date type data on x axis, there is a padding on both sides of the plot. But for bar charts, ...

  • 665 Views
  • 0 replies
  • 1 kudos
noimeta
by Contributor II
  • 2042 Views
  • 2 replies
  • 4 kudos

Resolved! Adjust label size in SQL visualization

Hi,Anyone knows if there's a way to adjust the font size of label in the SQL visualization? Our dashboard users complain that it's too small.

  • 2042 Views
  • 2 replies
  • 4 kudos
Latest Reply
susodapop
Contributor
  • 4 kudos

It's on our radar to make this customisable in the future. For now, browser zoom as suggested by @debayan is the suggested workaround.

  • 4 kudos
1 More Replies
Laure_Decaudin
by New Contributor
  • 1341 Views
  • 2 replies
  • 0 kudos

Order By disabled in sql dashboard

Hello, I have an issue, when I created my query, with an Order By, and my vizualization, everything was in the right order. Then, when I put it in my dashboard the order changed. As you can see with the pictures, when I clik on "edit visualization", ...

  • 1341 Views
  • 2 replies
  • 0 kudos
Latest Reply
Vidula
Honored Contributor
  • 0 kudos

Hi @Laure Decaudin​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Tha...

  • 0 kudos
1 More Replies
Labels