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: 
Data + AI Summit 2024 - Data Warehousing, Analytics, and BI

Forum Posts

MadelynM
by Databricks Employee
  • 825 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
  • 825 Views
  • 0 replies
  • 0 kudos
Akshay_Petkar
by Contributor
  • 421 Views
  • 2 replies
  • 0 kudos

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?

  • 421 Views
  • 2 replies
  • 0 kudos
Latest Reply
Mo
Databricks Employee
  • 0 kudos

hello @Akshay_Petkar, in your data tab, can't you create a dataset using "Create From SQL" and write a query like the following and use this dataset in your canvas? SELECT COUNT(sales_key) total_sales, distirict FROM my_table GROUP BY distirict ORDE...

  • 0 kudos
1 More Replies
noimeta
by Contributor III
  • 11924 Views
  • 1 replies
  • 0 kudos

Resolved! Parameter section missing in AI/BI Dashboard

Hi,I'm trying to individually parameterize visualization widgets by following this tutorial https://docs.databricks.com/en/dashboards/parameters.html#static-widget-parametersHowever, it seems the Parameter section is missing. Does anyone facing the s...

  • 11924 Views
  • 1 replies
  • 0 kudos
Latest Reply
noimeta
Contributor III
  • 0 kudos

I have found a solution. I have to toggle the show filters button, then the Parameter section will show up.

  • 0 kudos
BillSundwall
by New Contributor II
  • 739 Views
  • 1 replies
  • 1 kudos

Maps in AI/BI Dashboards?

Is there any official word as to when we can expect Chloropleth or Marker Map visuals in AI/BI Dashboards? I realize Legacy Dashboards are still supported, but it feels uncertain to build new ones with AI/BI Dashboards in GA.

  • 739 Views
  • 1 replies
  • 1 kudos
Latest Reply
eason_gao_db
Databricks Employee
  • 1 kudos

Great question! The team is actively working on supporting Maps in AI/BI Dashboards. You can expect Marker Map to be available in a few weeks and Choropleth to come early next year. 

  • 1 kudos
prasadvaze
by Valued Contributor II
  • 8790 Views
  • 11 replies
  • 10 kudos

Azure Synapse versus databricks SQL endpoint performance comparison

Has anyone done this and share details? I have a sample sql which ran on large SQL endpoint in 8min and synapse 1000DWU setting in 1hr. On small SQL endpoint it took 34min. What's the equivalent SQL Endpoint compute for Synapse@1000DWU? I know th...

  • 8790 Views
  • 11 replies
  • 10 kudos
Latest Reply
arslanapk99
New Contributor II
  • 10 kudos

the cost vary 

  • 10 kudos
10 More Replies
NikkG
by New Contributor
  • 245 Views
  • 0 replies
  • 0 kudos

Worker/Drive Node Config for Free Tier EastUS region

Hello,Right now I have chosen the free tier mode and region is east US. But I am unable to create a all purpose compute cluster. Any config I chose it says not supported. Any help is appreciated for pointing which config for worker and driver I shoul...

  • 245 Views
  • 0 replies
  • 0 kudos
cristianc
by Contributor
  • 480 Views
  • 2 replies
  • 0 kudos

How does the refresh work for AI/BI (formerly LakeView Dashboards)

Greetings,I'm writing this message because I want to understand how does the "automatic refresh" feature work for AI/BI dashboards that use SQL Serverless endpoints?I'm asking because sometimes the published dashboard refreshes when viewing the link ...

  • 480 Views
  • 2 replies
  • 0 kudos
Latest Reply
Walter_C
Databricks Employee
  • 0 kudos

The dashboard will refresh under conditions such as Manual refresh, scheduled refresh or if a parameter in the refresh changes it will hit the refresh option

  • 0 kudos
1 More Replies
151640
by New Contributor III
  • 521 Views
  • 2 replies
  • 0 kudos

Databricks JDBC driver. Databasemetadata.getColumns does not return columns of VARIANT type

Resultset returned by DatabaseMetadata.getColumns does not include the variant column in a table. Only includes the non-variant column.Databricks JDBC driver 02.06.40.1071create table tvariant(rnum int, c1 variant);

  • 521 Views
  • 2 replies
  • 0 kudos
Latest Reply
filipniziol
Contributor
  • 0 kudos

Hi @151640 ,According to the documentation VARIANT data type in not supported by Databricks JDBC driver.Here is the list of supported data types: 

  • 0 kudos
1 More Replies
andre_rizzatti
by New Contributor II
  • 1952 Views
  • 3 replies
  • 2 kudos

SQLWarehouse Case INsensitive

Good morning, is there any parameter or configuration that causes all my data to be consulted without case distinction? insensitive?

  • 1952 Views
  • 3 replies
  • 2 kudos
Latest Reply
MarianoRanu
New Contributor II
  • 2 kudos

Hi @raphaelblg ,do you know any update to this or any workaround?Regards,Mariano

  • 2 kudos
2 More Replies
techuser
by New Contributor III
  • 9791 Views
  • 6 replies
  • 1 kudos

Databricks Liquid Cluster

Hi,Is it possible to convert existing delta table with partition having data to clustering? If so can you please suggest the steps required? I tried and searched but couldn't find any. Is it that liquid clustering can be done only for new Delta table...

  • 9791 Views
  • 6 replies
  • 1 kudos
Latest Reply
Raja_Databricks
New Contributor III
  • 1 kudos

Does Liquid Clustering accepts Merge or How Upsert can be done efficiently with Liquid clustered delta table

  • 1 kudos
5 More Replies
Pavan3
by New Contributor II
  • 276 Views
  • 2 replies
  • 0 kudos

Regarding Database location in dbfs

Hi,I have used "SET spark.sql.warehouse.dir" which creates the directory by default.Then I have created the database by command "CREATE DATABASE IF NOT EXISTS database_name;",but when I used "DESCRIBE DATABASE database_name" I could not find the loca...

  • 276 Views
  • 2 replies
  • 0 kudos
Latest Reply
filipniziol
Contributor
  • 0 kudos

Hi @Pavan3 ,If running DESCRIBE DATABASE the location is empty, then was created in the default CATALOG directory.What you can do is to create any table in that database and run DESCRIBE DETAIL on that table:Hope it helps

  • 0 kudos
1 More Replies
apiury
by New Contributor III
  • 821 Views
  • 1 replies
  • 0 kudos

Connect NET app to delta table warehouse

Hi! I'm developing a .NET app and i want to use the databricks warehouse as database. I have gold delta tables that i want to query. In the documentation, i can see a ODBC/JDBC driver, are those connector fast? there are another way to connect? what ...

  • 821 Views
  • 1 replies
  • 0 kudos
Latest Reply
rangu
New Contributor III
  • 0 kudos

We have been using .Net apps connected to Databricks delta tables through Clusters, we have been using ODBC  to achieve this. However we recently hit a roadblock after UC migration, where the UC all purpose cluster started giving issues with queries ...

  • 0 kudos
Aya-Ahmed
by New Contributor II
  • 440 Views
  • 2 replies
  • 0 kudos

Parquet Encryption/Decryption in Databricks

Hi everyone,I'm curious about Databricks' approach to encrypting and decrypting Parquet files. Does Databricks adhere to standard encryption/decryption methods for Parquet? If not, what specific methods or techniques are used?I'd appreciate any insig...

  • 440 Views
  • 2 replies
  • 0 kudos
Latest Reply
Witold
Contributor III
  • 0 kudos

Since Databricks uses Spark, you should be able to use e.g. Columnar EncryptionBesides, you can look into this and aes-specific functions.

  • 0 kudos
1 More Replies
AndrejZ
by New Contributor
  • 383 Views
  • 1 replies
  • 0 kudos

Shared Parameters between queries on a dashboard

I would like to create a simple governance dashboard with multiple queries (a query to see user login events, a query to see sql statements ran, a query for jobs executed, etc.)What i would like to do is have a single user name parameter which would ...

  • 383 Views
  • 1 replies
  • 0 kudos
Latest Reply
Walter_C
Databricks Employee
  • 0 kudos

Yes you can set dashboard parameters so you provide the username on the parameter or widget and it gets distributed to the different queries https://docs.databricks.com/en/dashboards/parameters.html  

  • 0 kudos

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group
Labels
Top Kudoed Authors