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
  • 1340 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
  • 1340 Views
  • 0 replies
  • 0 kudos
martindlarsson
by New Contributor III
  • 782 Views
  • 3 replies
  • 1 kudos

Warning in dbt task

We are using dbt core and running our transformations in a dbt task. Since a few months ago we have started to see a warning message in our runs. This  started happening after an update of dbt core and it seems that Databricks needs to update the def...

  • 782 Views
  • 3 replies
  • 1 kudos
Latest Reply
martindlarsson
New Contributor III
  • 1 kudos

Both of you missed the sentence "Databricks needs to update the definition of the generated profiles file."The warning is regarding the structure of the profiles.yml which is generated by Databrick. This is not anything I as a user can change accept ...

  • 1 kudos
2 More Replies
kgilson
by New Contributor
  • 346 Views
  • 1 replies
  • 0 kudos

Databricks Apps connection to Azure SQL server

Hello,I am new to Databricks and was asked to evaluate the new Apps function as a way to publish dashboards.  We do not use Databricks today.  We have an Azure SQL database we use as a home grown warehouse.  The question is can I connect directly to ...

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

To connect your Azure SQL database to Databricks Apps, you will need to pull the data from the existing database into Databricks. Databricks Apps are designed to leverage the data and features within the Databricks platform, which means that the data...

  • 0 kudos
sruthianki
by New Contributor II
  • 510 Views
  • 3 replies
  • 0 kudos

Migrating huge table from synapse to databricks

Hi ,We are looking for a option to copy tables more than 50 TB to be copied from syanpse to databricks on weekly basis , please suggest of there are any feasible ways for samewe are using connector but it is taking too long to copyhttps://learn.micro...

  • 510 Views
  • 3 replies
  • 0 kudos
Latest Reply
-werners-
Esteemed Contributor III
  • 0 kudos

There is no databricks documentation on this as it is only involved for a very tiny bit:"CREATE TABLE catalog.schema.table USING PARQUET LOCATION 'url_to_the_parquet_files'.All the rest is done in Azure Data Factory, or you can even use the built-in ...

  • 0 kudos
2 More Replies
vaishalisai
by New Contributor II
  • 453 Views
  • 2 replies
  • 0 kudos

Account client not able to get workspace client

So I did U2M authentication for account-level operations -databricks auth login --host <account-login-url> --account-id <account-id>then I tried to run code-workspaces = account_client.workspaces.list()workspace_obj=account_client.get_workspace_clien...

  • 453 Views
  • 2 replies
  • 0 kudos
Latest Reply
vaishalisai
New Contributor II
  • 0 kudos

I am doing using a service principal so my .databrickscfg has -[databricks-demo]client_id = -----client_secret = ----host = https://accounts.cloud.databricks.com/account_id = ----   

  • 0 kudos
1 More Replies
mtr_nx
by New Contributor II
  • 602 Views
  • 2 replies
  • 0 kudos

Dashboarding Tooltips - How-To's?

Hi Folks, I am looking for any documentation on how Databricks Dashboards handle creating tooltips. Specifically I am interested in dashboards created in the SQL Warehouses (not Workspace Clusters, since using libraries like plotly can have custom to...

  • 602 Views
  • 2 replies
  • 0 kudos
Latest Reply
mtr_nx
New Contributor II
  • 0 kudos

Thank you for sharing this. Unfortunately it doesn't really contain much information on how to manage the tooltips that pop up when you hover over a bar or line in a chart/figure. That's what I am looking to customize in (or at least remove from) my ...

  • 0 kudos
1 More Replies
ianclari
by New Contributor
  • 397 Views
  • 1 replies
  • 0 kudos

Does PowerBI Online dashboard refresh require an on-premises data gateway?

Hi Team good day.I'd like to check on the pattern where dashboards are developed in PowerBI Desktop which are then published to PowerBI Online, using data from Databricks on AWS. In order to refresh the dashboards in PowerBI Online (whether on schedu...

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

To refresh dashboards in PowerBI Online using data from Databricks on AWS, an on-premises data gateway is not required. This is different from the scenario with Redshift, where an on-premises data gateway is necessary. For Databricks on AWS, you can ...

  • 0 kudos
as5
by New Contributor II
  • 3775 Views
  • 1 replies
  • 3 kudos

SQL Warehouse - increasing concurrent queries limit

Hello everyone,I would like to inquire about the possibility of increasing the default limit of concurrent queries on the cluster which is set to 10.While researching this topic, I noticed that there is no official documentation available regarding t...

Warehousing & Analytics
ConcurrentQueries
warehouse
  • 3775 Views
  • 1 replies
  • 3 kudos
Latest Reply
drag7ter2
New Contributor II
  • 3 kudos

Did you get an answer how to set spark.databricks.maxConcurrentRuns and spark.databricks.maxConcurrentQueries parameters in sql warehouse serverless cluster?

  • 3 kudos
Digvijay_11
by New Contributor
  • 749 Views
  • 1 replies
  • 0 kudos

SQL Warehouse - Auto Stop not working

We have Azure Databricks - SQL Serverless Warehouse with Classic configuration. The config details shared in below snip. As per the Auto Stop config, the Serverless warehouse should be stopped after 10 min of inactivity. However, when we were monitor...

Digvijay_11_3-1731482307233.png Digvijay_11_1-1731481623426.png Digvijay_11_2-1731481643294.png
  • 749 Views
  • 1 replies
  • 0 kudos
Latest Reply
MuthuLakshmi
Databricks Employee
  • 0 kudos

@Digvijay_11  A dbsql warehouse can be triggered not only by a query from a JDBC/ODBC client but also by an idle session, as sessions are managed within the backend clusters. Clusters must be running to maintain these sessions, even before a query is...

  • 0 kudos
illumety-jh
by New Contributor II
  • 2450 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...

  • 2450 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
  • 901 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...

  • 901 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
  • 2553 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...

  • 2553 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
  • 1118 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...

  • 1118 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
  • 534 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...

  • 534 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
  • 398 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...

  • 398 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