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
  • 1115 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
  • 1115 Views
  • 0 replies
  • 0 kudos
Hubert-Dudek
by Esteemed Contributor III
  • 12249 Views
  • 2 replies
  • 0 kudos

Optimizing SQL Databricks Warehouse Timeout Settings

Did you know the default timeout setting for SQL #databricks Warehouse is two days?The default timeout can be too long for most use cases. You can easily change this for your session or in the general SQL warehouse configuration.

ezgif-1-a917957651.gif
  • 12249 Views
  • 2 replies
  • 0 kudos
Latest Reply
rj_22588
New Contributor II
  • 0 kudos

Hi @Hubert-Dudek we have a java service which uses JDBC Template for connecting to databricks warehouse. We recently set a high connection idle timeout and maxLifeTime for our hikari pool connection. We are now seeing error related to invalid session...

  • 0 kudos
1 More Replies
Martin_Pham
by New Contributor III
  • 1347 Views
  • 3 replies
  • 1 kudos

Resolved! SQLWarehouse Case INsensitive

Does SQL Warehouse now have a feature that allows me to query all data without distinguishing between uppercase and lowercase?

  • 1347 Views
  • 3 replies
  • 1 kudos
Latest Reply
szymon_dybczak
Esteemed Contributor III
  • 1 kudos

Hi @Martin_Pham ,At the current moment SQL Warehouses don't have this option. But according to one of the employees at databricks, this feature is coming soon: https://community.databricks.com/t5/warehousing-analytics/sqlwarehouse-case-insensitive/td...

  • 1 kudos
2 More Replies
pavel_cerny
by New Contributor II
  • 1053 Views
  • 0 replies
  • 1 kudos

Databricks JDBC driver fails with socket read timeout

Application connects to Databricks serverless SQL warehouse via Databricks JDBC driver. It executes SQL select statements only. We see small number of statements failed each day with the following error detail: java.sql.SQLException: [Databricks][JDB...

  • 1053 Views
  • 0 replies
  • 1 kudos
jon1
by New Contributor II
  • 1461 Views
  • 2 replies
  • 0 kudos

How to ensure all resources are released when closing a Connection via DataBricks JDBC Driver?

Hi there,I'm building a Sink that uses the Databricks JDBC Driver version 2.6.27. It appears that regardless of using a try-with-resources block and explicitly closing the Connection, the driver's internals are not releasing IdleConnectionEvictor thr...

  • 1461 Views
  • 2 replies
  • 0 kudos
Latest Reply
RakeshSen01
New Contributor II
  • 0 kudos

Still not fixed got 14k instances of com.databricks.client.jdbc42.internal.apache.http.impl.client.IdleConnectionEvictor 14,037 (0%) 673,776 B (0%) n/a And due to that application got to crashed. can you please help out as this is blocking to release...

  • 0 kudos
1 More Replies
swathiG
by New Contributor III
  • 1150 Views
  • 3 replies
  • 1 kudos

Load backup file

Hi Team,There is a requirement to load a backup file into a database inside a SQL Warehouse. However, I don't see any option to directly load abackup file.I have tried reading the backup file using a notebook, but I’m unable to interpret the contents...

swathiG_0-1723483143998.png
  • 1150 Views
  • 3 replies
  • 1 kudos
Latest Reply
swathiG
New Contributor III
  • 1 kudos

@szymon_dybczak  could you please suggest some other options for how I can proceed to load data from the database?

  • 1 kudos
2 More Replies
AndreasFuchs
by New Contributor
  • 388 Views
  • 0 replies
  • 0 kudos

Cost Tracing by accessed unity catalog catalog schema, sharing of sql warehouse

Hi community,we have several databricks workspaces per different teams and in each workspace several use case covered.How can we trace the costs per individual use cost for SQL Warehosue / serverless in case we use one SQL warehouse per workspace to ...

  • 388 Views
  • 0 replies
  • 0 kudos
Anonymous3
by New Contributor
  • 628 Views
  • 1 replies
  • 0 kudos

How to migrate Legacy Dashboard from one workspace to another workspace?

Is it possible to migrate Databricks Legacy Dashboards along with associated components such as queries and datasets from one workspace to another? I have attempted to export the Legacy Dashboards along with the queries and datasets, but upon importi...

  • 628 Views
  • 1 replies
  • 0 kudos
Latest Reply
holly
Databricks Employee
  • 0 kudos

Hello, to migrate between workspaces you'll need a different strategy based on the asset type Legacy dashboards you have completed, but for anyone reading you can use the 'export' functionalityQueries: you can either put them together in a folder and...

  • 0 kudos
dweben
by New Contributor II
  • 566 Views
  • 0 replies
  • 0 kudos

Databricks azure dashboard chart issue

Hi all,Just started using Db Dashboards on Azure. While generating a line chart with a x-axis value based on a date data type I've applied a filter which removes some of the data. The above is without filtering, the below is with filtering. You can o...

dweben_0-1722274099938.png dweben_1-1722274250694.png
  • 566 Views
  • 0 replies
  • 0 kudos
PM0
by New Contributor
  • 915 Views
  • 0 replies
  • 0 kudos

Rate limit Usage

We are having Databricks tables and we have an API which query that data, the query will be dynamic and API would allow user to query anything. However users can query lot of data and consume lot of DBU but generic rate limiting wont help, as any sin...

  • 915 Views
  • 0 replies
  • 0 kudos
pauloquantile
by New Contributor III
  • 13418 Views
  • 6 replies
  • 1 kudos

PowerBI "Token expired while fetching results: TEAuthTokenExpired."

Hi everyone,We are at the moment stumbeling upon a big challenge with loading data into PowerBI. I need some advice!To give a bit of conext: we introduced Databricks instead of Azure Synapse for a client of ours. We are currently busy with moving all...

pauloquantile_0-1693824616520.png
  • 13418 Views
  • 6 replies
  • 1 kudos
Latest Reply
viralpatel
New Contributor II
  • 1 kudos

@Retired_mod Is there any further update from Databricks which can be helpful here OR what @pauloquantile mentioned is the only workaround solution?

  • 1 kudos
5 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