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
  • 1751 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
  • 1751 Views
  • 0 replies
  • 0 kudos
koral
by New Contributor
  • 127 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!

  • 127 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
leo-machado
by New Contributor III
  • 1241 Views
  • 9 replies
  • 4 kudos

(Big) Problem with SQL Warehouse Auto stop

Long story short, I'm not sure if this is an already known problem, but the Auto Stop feature on SQL Warehouses after minutes of inactivity is not working properly.We started using SQL Warehouses more aggressively this December when we scaled up one ...

image (2).png Screenshot 2025-01-02 at 10.31.27.png
  • 1241 Views
  • 9 replies
  • 4 kudos
Latest Reply
pdiamond
Contributor
  • 4 kudos

One thing we noticed is that the "Monitoring" tab of the SQL Warehouse page can be misleading because it doesn't always account for time spent fetching & serving the data to the client, only the actual query execution time. This was confirmed by Supp...

  • 4 kudos
8 More Replies
MightyMasdo
by New Contributor II
  • 1369 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...

  • 1369 Views
  • 6 replies
  • 2 kudos
Latest Reply
vr
Contributor
  • 2 kudos

Code?

  • 2 kudos
5 More Replies
Bakkie
by New Contributor II
  • 857 Views
  • 1 replies
  • 1 kudos

Databricks Apps based on Streamlit could not find a valid JAVA_HOME installation

We are launching our first Databricks Apps based on Streamlit.The App works when simply running the notebook in our workspace, but fails after deployment due to "could not find a valid JAVA_HOME installation" when running in the system environment.We...

  • 857 Views
  • 1 replies
  • 1 kudos
Latest Reply
alan-nousot
New Contributor II
  • 1 kudos

any update on this? Currently running into the issue of java_home not being set for pyspark

  • 1 kudos
ossinova
by Contributor II
  • 554 Views
  • 1 replies
  • 0 kudos

Coss page filters - AI/BI Dasboards

When creating a dashboard with multiple pages connected to one dataset. It seems that only visual elements on the same page that the filter is on takes effect. Is there a way to filter all visual elements regardless of which page the filter is on?I h...

  • 554 Views
  • 1 replies
  • 0 kudos
Latest Reply
SP_6721
New Contributor II
  • 0 kudos

It seems that, filter can be applied to only to visualizations on the same page that share the same dataset. Currently, there are no a built in features to create a global filter that works on multiple pages within a dashboard.To achieve filtering ac...

  • 0 kudos
DataFarmer
by New Contributor II
  • 6472 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...

  • 6472 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
  • 1138 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...

  • 1138 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
  • 9571 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...

  • 9571 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
jackintosh
by New Contributor
  • 605 Views
  • 0 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...

  • 605 Views
  • 0 replies
  • 0 kudos
Pramod_G
by New Contributor II
  • 556 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
  • 556 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
  • 810 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...

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

  • 0 kudos
jonh
by New Contributor III
  • 1414 Views
  • 6 replies
  • 1 kudos

Resolved! AI/BI Dashboards

We need to build some BI dashboards for a client. We are having issues to find a way to Download a dataset behind a chart. Ideally the dataset subset after appliying a set of filters. The documentation says here that the full dataset could also be do...

jonh_0-1742476574674.png jonh_1-1742476650926.png
  • 1414 Views
  • 6 replies
  • 1 kudos
Latest Reply
Shua42
Databricks Employee
  • 1 kudos

I don't think promoting them to Admins is the best approach. You should be able to assign them to appropriate groups and set permissions to they data you want devs and guests to have query access to, respectively. Then, in terms of sharing the dashbo...

  • 1 kudos
5 More Replies
AnaMocanu
by Contributor
  • 2255 Views
  • 6 replies
  • 2 kudos

Resolved! Streamlit app on Databricks doesn't recognise the DATABRICKS_WAREHOUSE_ID in the yaml file

Hey everyone,So I managed to create a Streamlit app on Databricks, works fine deployed in the cloud.However, when I try to run it locally, it complains about "assert os.getenv('DATABRICKS_WAREHOUSE_ID'), "DATABRICKS_WAREHOUSE_ID must be set in app.ya...

  • 2255 Views
  • 6 replies
  • 2 kudos
Latest Reply
pdiamond
Contributor
  • 2 kudos

I figured it out this morning. You have to use an underscore in the yaml file instead of a dash. This works for me:  - name: "DATABRICKS_WAREHOUSE_ID"    valueFrom: "sql_warehouse"

  • 2 kudos
5 More Replies