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
  • 1183 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
  • 1183 Views
  • 0 replies
  • 0 kudos
illumety-jh
by New Contributor II
  • 2300 Views
  • 2 replies
  • 1 kudos

Accessing Unity Catalog Externally (Outside of Databricks) as Hive Metastore

Hello,I'm designing a system that combines a lake-house and a real-time path that federates across multiple databases. The requirements led us to adopt Starburst Galaxy (a cloud-hosted distributed query engine) for query federation across the various...

  • 2300 Views
  • 2 replies
  • 1 kudos
Latest Reply
Sijay
New Contributor II
  • 1 kudos

Hello there!So any updates so far? Also interesting in this solution.

  • 1 kudos
1 More Replies
FLK
by New Contributor II
  • 811 Views
  • 2 replies
  • 1 kudos

Resolved! Dashboards: date (range) picker doesn't go along with another parameterized filter

 I added a filter with the :name_parameter to the dashboard and it works fine.But if I add a date range picker for the date axis it doesn't do any effect (standalone, without the other filter enabled, it is working). It seems to me that the date pick...

  • 811 Views
  • 2 replies
  • 1 kudos
Latest Reply
FLK
New Contributor II
  • 1 kudos

Thanks a lot. I guess this was a case of not seeing the forest for the trees. But still, maybe the could add a tooltip or so for this field.  

  • 1 kudos
1 More Replies
KrzysztofPrzyso
by New Contributor III
  • 2435 Views
  • 3 replies
  • 3 kudos

exposing RAW files using read_files based views, partition discovery and skipping, performance issue

Hi,As a formal requirement in my project I need to keep original, raw (mainly CSVs and XMLs) files on the lake. Later on they are being ingested into Delta format backed medallion stages, bronze, silver, gold etc.From the audit, operations and discov...

  • 2435 Views
  • 3 replies
  • 3 kudos
Latest Reply
KrzysztofPrzyso
New Contributor III
  • 3 kudos

Many thanks for raising it @bobmclaren .@Retired_mod Do you have any updates on the above?

  • 3 kudos
2 More Replies
Kyle2
by New Contributor II
  • 967 Views
  • 2 replies
  • 0 kudos

Databricks JDBC driver fails with socket read timeout

We work with a application that connects to our Databricks serverless SQL warehouse via Databricks JDBC driver. It runs a few thousand SQL select statements everyday, and a small percentage of them will fail with the following error details: java.sql...

  • 967 Views
  • 2 replies
  • 0 kudos
Latest Reply
Rafael-Sousa
Contributor II
  • 0 kudos

Did you tried to increase the socket timeout?

  • 0 kudos
1 More Replies
alvaromoure
by New Contributor
  • 462 Views
  • 1 replies
  • 0 kudos

How to use DESCRIBE DETAIL in Databricks Dashboards

Hi all, I am currently stuck because runing DESCRIBE DETAL in my catalog's tables return an error like:[PARSE_SYNTAX_ERROR] Syntax error at or near 'hive_metastore'. SQLSTATE: 42601 (line 1, pos 21)Why is this not supported in the dasboards but the s...

  • 462 Views
  • 1 replies
  • 0 kudos
Latest Reply
pranav_k1
New Contributor III
  • 0 kudos

Both DESCRIBE and DESCRIBE DETAIL are supported by databricks sqlBut DESCRIBE DETAIL is only supported for tables not for viewsError you are getting is due to the SQL statement you have used is not valid and hence cannot be executedPlease check your ...

  • 0 kudos
iblaine
by New Contributor II
  • 340 Views
  • 2 replies
  • 0 kudos

Plans to upgrade API to get dashboard details for non-legacy dashboards?

I'm interested in using the API to list all dashboards, but the API shows legacy dashboards only. Are there any plans to fix this API call to show all dashboards?I'm using this API call: https://docs.databricks.com/api/workspace/dashboards/listAnd th...

  • 340 Views
  • 2 replies
  • 0 kudos
Latest Reply
iblaine
New Contributor II
  • 0 kudos

I understand the API is valid for legacy dashboards, but I need to include all dashboards, legacy or not.,

  • 0 kudos
1 More Replies
Angel_Abundez
by New Contributor
  • 324 Views
  • 1 replies
  • 0 kudos

When will AI/BI Dashboards support Map visuals

Hello,Currently, AI/BI Dashboards do not support Maps. This is a very important visual for those of us with geocoded data. We're stuck using Legacy Dashboards for this. Any ETA? Is this on the roadmap somewhere?Thanks,Angel

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

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. 

  • 0 kudos
NikkG
by New Contributor
  • 414 Views
  • 1 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...

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

Can you please provide an screenshot of your cluster configuration and the error message received?  

  • 0 kudos
Brammer88
by New Contributor III
  • 4052 Views
  • 13 replies
  • 6 kudos

How do I setup a connection to get data from unity catalog into MS Access?

Dear community,Im trying to setup a connection to get data from a catalog / underlying tables from that catalog and load it directly into MS Access 365 (latest version). Is it possible to do this? What would be the best practice? Thanks,Bram

  • 4052 Views
  • 13 replies
  • 6 kudos
Latest Reply
atrev66
New Contributor II
  • 6 kudos

Hey guys,See here for a solution to this issue. You can specify the catalog when you setup the odbc driver.ODBC data source to connect to a Databricks catalo... - Databricks Community - 96354 

  • 6 kudos
12 More Replies
ms_221
by New Contributor II
  • 909 Views
  • 1 replies
  • 1 kudos

Resolved! SparkConnectGrpcException

Getting the below error when reading the snowflake tables data .We are successfully able to connect the respective tables .cannot display the data and other transformations.SparkConnectGrpcException: (net.snowflake.client.jdbc.SnowflakeSQLException) ...

  • 909 Views
  • 1 replies
  • 1 kudos
Latest Reply
filipniziol
Esteemed Contributor
  • 1 kudos

Hi @ms_221 ,The SparkConnectGrpcException you're encountering, specifically mentioning that the incoming request with a certain IP/Token is not allowed to access Snowflake, suggests an issue related to network policies or access control within Snowfl...

  • 1 kudos
_Sumit_Kate
by New Contributor II
  • 587 Views
  • 1 replies
  • 0 kudos

Getting PARSE_SYNTAX_ERROR for DECLARE VARIABLE statement in ODBC C#

I am trying to declare variable in SQL statement and try to execute it via ODBC C# driver(System.Data.Odbc 8.0.0) but it fails with parse syntax error.When I try the same query on SQL editor, it runs. Query:DECLARE VARIABLE users_core__user_name_last...

  • 587 Views
  • 1 replies
  • 0 kudos
Latest Reply
NandiniN
Databricks Employee
  • 0 kudos

  Hello @_Sumit_Kate  Not all databases support variable declaration in the same way. It is possible System.Data.Odbc does not support it, in Databricks we use Simba ODBC drivers. But I would say let's check the official document too - https://learn....

  • 0 kudos
Akshay_Petkar
by Contributor II
  • 482 Views
  • 1 replies
  • 1 kudos

Issue with Data Masking Persistence After Table Overwrite in Databricks

I have implemented data masking on my Databricks table, and it works well when I append new rows, as the masking and unmasking function as expected. However, when I overwrite the table, the unmasking does not seem to work correctly, and the data rema...

  • 482 Views
  • 1 replies
  • 1 kudos
Latest Reply
agallard
Contributor
  • 1 kudos

Hi @Akshay_Petkar,The issue with data masking not persisting correctly after an overwrite in Databricks likely stems from how the overwrite operation interacts with masked data and user-defined functions for masking/unmasking. In Databricks, overwrit...

  • 1 kudos
DilyanDimitrov
by New Contributor
  • 796 Views
  • 3 replies
  • 0 kudos

Does the ODBC driver for databricks support parameterized queries?

Hi all,I am using the official ODBC driver for databricks downloaded from here (the latest version) and trying to have a dotnet API (C#) fetching data from databricks via the driver. I am using the general Microsoft package for ODBC connection - Syst...

  • 796 Views
  • 3 replies
  • 0 kudos
Latest Reply
_Sumit_Kate
New Contributor II
  • 0 kudos

Instead of named parameters, the ODBC .NET Provider uses positional parameters that are marked with a question mark (?) in the syntax of the command text.Please make sure that UseNativeQuery to false(0) in the odbc connection string as they have ment...

  • 0 kudos
2 More Replies
Rahul_Lalwani
by New Contributor II
  • 638 Views
  • 2 replies
  • 0 kudos

Shared Cluster running pushdown queries in Azure SQL

I just want to run push down queries for example update or run procedures into azure sql server using shared cluster.We have built modules which were running without any issues using spark gateway to create a connection to azure sql and running updat...

  • 638 Views
  • 2 replies
  • 0 kudos
Latest Reply
SathyaSDE
Contributor
  • 0 kudos

Hi,Did you try like below ?# Define the JDBC connection propertiesjdbc_url = "jdbc:sqlserver://<your_server>.database.windows.net:1433;database=<your_database>"connection_properties = {    "user": "<your_username>",    "password": "<your_password>", ...

  • 0 kudos
1 More Replies

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