- 1165 Views
- 1 replies
- 1 kudos
Best Practices for Optimizing Delta Lake Performance
I’m currently working on a project using Delta Lake on Databricks and would like to optimize performance for both batch and streaming workloads.
- 1165 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @joshbuttler ,It's a big topic and it really depends on the use case. You can follow some guides/recommendations from databricks documentation:- Optimization recommendations on Databricks | Databricks on AWS- Use liquid clustering for Delta tables...
- 1 kudos
- 3273 Views
- 4 replies
- 0 kudos
Has anyone being able to connect to Databricks using ODBC?
I'm trying to connect to the Databricks cluster from the Excel using ODBC and following this official guide:https://docs.databricks.com/en/integrations/excel.html#connect-from-microsoft-excelBut the authentication is always failing, returning "500 In...
- 3273 Views
- 4 replies
- 0 kudos
- 0 kudos
Hi @Vadimalk ,Could you check if you have following options enabled in simba driver configuration:
- 0 kudos
- 930 Views
- 0 replies
- 0 kudos
Account Level API GET Call requiring User-Agent Header
We recently Enabled Unity Catalog so using Account Level API and little stuck on a GET call. For some reason, just the GET call requires a User-Agent header while POST, PUT, PATCH.. all work without it. For workspace API, there was no need for User-A...
- 930 Views
- 0 replies
- 0 kudos
- 1730 Views
- 1 replies
- 1 kudos
Summit23
I have really enjoyed the summit so far! I am a biostatistics graduate student at Harvard and am learning so much here.
- 1730 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi,If you had a great time at the Summit, be sure to visit our community events portal for upcoming events and join your regional user group for meetups.Thanks,Anushree
- 1 kudos
- 1723 Views
- 1 replies
- 0 kudos
Summit 2024
It has been an exciting event that brought together industry leaders, researchers, and practitioners to explore the latest advancements in artificial intelligence and data science. With cutting-edge presentations, hands-on workshops, and networking o...
- 1723 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi,If you had a great time at the Summit, be sure to visit our community events portal for upcoming events and join your regional user group for meetups.Thanks,Anushree
- 0 kudos
- 3290 Views
- 1 replies
- 0 kudos
- 3290 Views
- 1 replies
- 0 kudos
- 0 kudos
You can leverage this code base. It works as expected using "next_page_token" parameter-Don't forget to mark this solution as correct if this helped you import requests token = 'your token' url = 'your URL' params = {'expand_tasks': 'true'} heade...
- 0 kudos
- 1461 Views
- 1 replies
- 0 kudos
Unity Catalog
Can MLflow Experiments be incorporated into Unity Catalog (may be in volume or somewhere in unity catalog) similar to models and feature tables?
- 1461 Views
- 1 replies
- 0 kudos
- 0 kudos
As of now Databricks supports DBFS, S3, and Azure Blob storage artifact locations. Our teams are working on intruducing Volumes as repository which might be coming soon
- 0 kudos
- 1364 Views
- 1 replies
- 1 kudos
Troubleshoot in Databricks
Hi everyone,I’m having trouble with a query in Databricks. My code seems correct, but I’m getting unexpected results. Can anyone help me troubleshoot this or provide tips for debugging in Databricks?Thanks in advance! locksmith
- 1364 Views
- 1 replies
- 1 kudos
- 1 kudos
It's hard to advice when you didn't provide any code. But you can try to use debugger inside notebook:
- 1 kudos
- 12584 Views
- 13 replies
- 3 kudos
Resolved! Unable to access Account console under Azure Databricks
I am the only user for the Azure enviornment and assigned global admin.For the resource group, I am the owner.For the Azure Databricks Service I am the service admin already.I would like to try to go into the Account console to make some changes for ...
- 12584 Views
- 13 replies
- 3 kudos
- 2888 Views
- 3 replies
- 0 kudos
INVALID_PARAMETER_VALUE: There are more than 1001 files. Please specify [LIMIT] to limit the num....
I am running Azure Databricks DBX Runtime 13.3 and I am seeing the following error in my workspace:Last execution failed# doesn't work in DBX Runtime 13.3 and above# limitation is it can't read more than 1001 filesdbutils.fs.ls("[path]")AnalysisExcep...
- 2888 Views
- 3 replies
- 0 kudos
- 0 kudos
@Retired_mod how to resolve this issue? I have faced the same issue on dbr 14.3 and dbr 15.4 version unity enabled cluster. Can you please let us know the workaround for it?
- 0 kudos
- 10752 Views
- 6 replies
- 2 kudos
Resolved! Error on UC Liquid Clustering
I know we have 4 keys max on cluster by () for both z-order and partition keys. I got some issues when adding 4 keys and 1 specific key triggers that error (I was not expecting as this is about Create Table) . Stats makes sense if you need to optimiz...
- 10752 Views
- 6 replies
- 2 kudos
- 2 kudos
Is Liquid cluster also helpful for high cardinality columns for a table Join?
- 2 kudos
- 3919 Views
- 2 replies
- 1 kudos
Resolved! Data bricks Bundle - 'include' section does not match any files.
Hello Community,I’m encountering the following error while working on my project:Error: ${var.FILE_NAME} defined in 'include' section does not match any files.Has anyone faced this issue before? I'm using variables to include specific files, but it s...
- 3919 Views
- 2 replies
- 1 kudos
- 1 kudos
Hi @AkhilVydyula ,You can start by updating your cli. I've seen some really weird errors with older cli versions.
- 1 kudos
- 791 Views
- 0 replies
- 0 kudos
Creation of live consumption of MSSQL CDC via DLT
HelloI am bit surprised - but I don't see any default possibility of creating continous pipeline for fetching updates from MSSQL, and inserting them into delta lake - is it true - or am I missing something? To be clear - I know we can do that semi-li...
- 791 Views
- 0 replies
- 0 kudos
- 4452 Views
- 5 replies
- 6 kudos
Resolved! Looking for Databricks Study Materials/Resources
Hello,I’m looking for study materials or resources to help me learn Databricks more effectively. Any recommendations would be greatly appreciated!
- 4452 Views
- 5 replies
- 6 kudos
- 6 kudos
@igor779, @Rishabh-Pandey and @szymon_dybczak .Thank you all for the suggestions! Unfortunately, I don’t have access to content from partner companies and mainly rely on free resources for my studies.
- 6 kudos
- 1448 Views
- 0 replies
- 0 kudos
Issues with incremental data processing within Delta Live Tables
Hi!I have an problem with incrementally processing data within my Delta Live Tables (DLT) pipeline. I have a raw file (in Delta format) where new data is added each day. When I run my DLT pipeline I only want the new data to be processed. As an examp...
- 1448 Views
- 0 replies
- 0 kudos
