cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

2vinodhkumar
by New Contributor II
  • 574 Views
  • 1 replies
  • 0 kudos

Autoloader - Ingestion of CSV files when there is not operation column

Hi,We are working on ingesting multiple files from S3. The files name are fixed based on our source system, Files get replaced frequently with full feed. In DLT when we process new file we have to delete the records processed earlier of the same file...

  • 574 Views
  • 1 replies
  • 0 kudos
crankerkor
by New Contributor III
  • 3450 Views
  • 3 replies
  • 1 kudos

Resolved! Databricks JDBC SQL Warehouse Encoding Issue

Hi Everyone.I am trying to connect and read data from the Databricks table using SQL Warehouse and return it using Azure API.However, the non-English characters, for example, 'Ä', are present in the response as following: ��.I am using the databricks...

  • 3450 Views
  • 3 replies
  • 1 kudos
Latest Reply
151640
New Contributor III
  • 1 kudos

If Databricks support/Product Management following the forum, note that PDF from SIMBA in 2.6.28 does not discuss the name-value pairs in the above solution.Other errata includes PreparedMetadataLimitZero.

  • 1 kudos
2 More Replies
yvuignie
by Contributor
  • 8059 Views
  • 12 replies
  • 3 kudos

Resolved! Unity catalog - How do you modify groups properly ?

Hello,What is the best practice to modify/delete/recreate groups properly ?In order to rename a group, the only mean was to delete/recreate. But after deletion in the account console, the permissions granted to the deleted groups in the tables were i...

  • 8059 Views
  • 12 replies
  • 3 kudos
Latest Reply
RobinK
Contributor
  • 3 kudos

Hello,I have exactly the same issue - I am also using terraform.I deleted a group and the catalog permissions are in bad state.  I am not able to revoke access to this group using the Databricks UI nor REST API. I also tried to recreate the group wit...

  • 3 kudos
11 More Replies
data-engineer-d
by Contributor
  • 1909 Views
  • 1 replies
  • 2 kudos

Liquid Clustering - Number of files are increasing

We enabled liquid clustering on one of the large tables (380GBs). This table goes many operations daily, which improved many folds after liquid clustering. However, after enabling liquid clustering and optimizing it number of files are increased.Prev...

Data Engineering
Databricks
delta
Liquid clustering
  • 1909 Views
  • 1 replies
  • 2 kudos
Latest Reply
data-engineer-d
Contributor
  • 2 kudos

Thank you for detailed explanation @Retired_mod .

  • 2 kudos
GeKo
by New Contributor III
  • 2040 Views
  • 1 replies
  • 1 kudos

Resolved! Asset Bundles : how to conditionally set content of a template file

Hello,since Asset Bundles is based on GO templating mechanism, I am wondering how it is possible to use IF-ELSE construct within a template file, to define which file content will be set in the generated file ( I want to have that in my custom templa...

Data Engineering
asset bundle
bundles
template
  • 2040 Views
  • 1 replies
  • 1 kudos
Latest Reply
GeKo
New Contributor III
  • 1 kudos

Never mind....I figured out the solution I just have to prefix my template file with ".tmpl", then it gets rendered correctly

  • 1 kudos
ajithgaade
by New Contributor III
  • 1125 Views
  • 4 replies
  • 0 kudos

Databricks Job Params

Hi,Job params override the task params(same name params). Is there a way task params override the job params.Use case:job params: a = "param-1".job has 12 tasks. 10 of them should use job param(a = "param-1").2 of them should override the job param(a...

  • 1125 Views
  • 4 replies
  • 0 kudos
Latest Reply
szymon_dybczak
Esteemed Contributor III
  • 0 kudos

Hi @ajithgaade,Unfortunately, I don't think it is currently possible. It's clearly stated in documentation that:" Job parameters take precedence over task parameters. If a job parameter and a task parameter have the same key, the job parameter overri...

  • 0 kudos
3 More Replies
DataSax
by New Contributor III
  • 2903 Views
  • 4 replies
  • 3 kudos

Resolved! Just a beginner in Data Engineer

Hi Everyone,I am happy to be part of this great community.I just determined to be a Data Engineer by profession and I will need a lot of advice on how I can quickly grab it and become  a professional.I have Python Programming knowledge and Web develo...

  • 2903 Views
  • 4 replies
  • 3 kudos
Latest Reply
szymon_dybczak
Esteemed Contributor III
  • 3 kudos

Most import thing, at least at the beginning of your data journey is to grasp a good understanding of SQL. It's cornerstone in data world.Definitely you should familiarize yourself with a concept of data modeling, especially dimensional modeling that...

  • 3 kudos
3 More Replies
taimoor123
by New Contributor
  • 1058 Views
  • 1 replies
  • 0 kudos

Failure to Create Materialize View - Error Starting DLT Service on Databricks Cluster xxxx-xxxxxx-xx

 Hi,I am trying to create a materialized view; however, it failed. I could not find any reason for this issue.Cluster Summary:Cluster Type: SQL warehouse serverless with Unity CatalogWorkers: 1-4 Workers (16-64 GB Memory, 4-16 Cores)Driver: 1 Driver ...

taimoor123_0-1718271224512.png taimoor123_2-1718272469077.png
  • 1058 Views
  • 1 replies
  • 0 kudos
Latest Reply
gabsylvain
Databricks Employee
  • 0 kudos

Hey @taimoor123 , could you share the stack trace for the error please ?  Also, I find it a bit confusing. You mention you are using a Serverless SQL warehouse to run the query, but you are also providing the details of the configuration of what seem...

  • 0 kudos
Gareema
by New Contributor III
  • 1145 Views
  • 3 replies
  • 2 kudos

Data Lineage with Apply Changes

Hello TeamI am using DLT. I am able to see the lineage when doing normal process. However as soon as I use 'APPLY_Changes' feature after the lineag ebreaks and I am no more able to see the Data lineage from the catalog after going to table. Is there ...

Gareema_0-1720379993368.png
  • 1145 Views
  • 3 replies
  • 2 kudos
Latest Reply
Gareema
New Contributor III
  • 2 kudos

@Retired_mod : Is there any way this can be achieved or can we expect this problem to be resolved in next releases?

  • 2 kudos
2 More Replies
leungi
by Contributor
  • 903 Views
  • 2 replies
  • 0 kudos

Resolved! Init Script Fails Intermittently on Workflow Job

An init script is used to install system libraries, per below.Adding the script to a Personal Compute consistently works. The same script is added to a Workflows job via cluster config, which intermittently fails, as shown in error message below.Both...

leungi_0-1718291897408.png
  • 903 Views
  • 2 replies
  • 0 kudos
Latest Reply
amr
Databricks Employee
  • 0 kudos

Check the cluster event log to see if there is a clue why the script is failing. if the script failed and returned none zero status the cluster wont start

  • 0 kudos
1 More Replies
Enrique1987
by New Contributor III
  • 874 Views
  • 1 replies
  • 0 kudos

Resolved! Overwriting mode do not overwrite

I have the following codePreviously I have a delta table with 180 columns in my_path´, I select a column and try to overwrite columns_to_select = ["one_column"] df_one_column = df.select(*columns_to_select) df_one_column.write.format("de...

  • 874 Views
  • 1 replies
  • 0 kudos
Latest Reply
Enrique1987
New Contributor III
  • 0 kudos

ok I get the Issue  .option("mergeSchema", "true")  Is usefull to add more columns, but if you want to reduce columns in your target delta.Then you need.option("overwriteSchema", "true") 

  • 0 kudos
Phani1
by Valued Contributor II
  • 372 Views
  • 1 replies
  • 0 kudos

Metastore Access

Hi team,We are operating on a single-tenant basis with just one metastore. How can other teams use Databricks Unity Catalog without being granted access to our metadata within single tenantRegards,Janga 

  • 372 Views
  • 1 replies
  • 0 kudos
Latest Reply
jacovangelder
Honored Contributor
  • 0 kudos

You can enable/set workspace catalog isolation for each catalog used by your teams. That way, they'll only be able to see their own catalog and corresponding data assets.

  • 0 kudos
giladba
by New Contributor III
  • 895 Views
  • 4 replies
  • 0 kudos

Databricks API - Create Connection

Hi,Is it possible to use the Databricks API to create a connection to a different Azure Databricks workspace?Thanks

  • 895 Views
  • 4 replies
  • 0 kudos
Latest Reply
giladba
New Contributor III
  • 0 kudos

My apologies for not being cleared in the first post.Terraform can handle it. The API is probably behind and can't handle the connection to Databricks yet. The best solution would probably be to just move to Unity Catalog...Thanks for your quick repl...

  • 0 kudos
3 More Replies
Chvyaken
by New Contributor III
  • 1598 Views
  • 5 replies
  • 7 kudos

Resolved! Change Runtime version from 10.4 to 11.3 in ADF

Hello! At the moment, I am considering replacing runtime 10.4 with runtime 11.3 in my ADF. I would like to know how big the differences are between them, and if I can just change the version without worrying about breaking anything? 

Chvyaken_0-1720363212242.png
  • 1598 Views
  • 5 replies
  • 7 kudos
Latest Reply
Witold
Honored Contributor
  • 7 kudos

On thing worth mentioning is the DBR Migration Guide. There you'll find all potential changes between the runtimes.

  • 7 kudos
4 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