cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Live Tables: Too much time to do the "setting up"

jorgemarmol
New Contributor II

Hello community!

Recently I have been working in delta live table for a big project. My team and me have been studying so much and finally we have built a good pipeline with CDC that load 608 entities (and, therefore, 608 delta live tables and 608 materialized views).

The issue is not the load, although there are many tables, the issue is the setting up process. The total time is 1h 30 min in which almost 1 h (or more) is setting up the tables process. 

jorgemarmol_0-1688633577282.png

 

Anyone have an idea of why could have been happening it or how could I accelerate this first process? Thank you so much! 

4 REPLIES 4

PearceR
New Contributor III

I have been having similar problems, any insight into this would be great.

anandh
New Contributor II

I am facing same issues while acquiring the resource to run the DLT pipeline and its taking too much time to setup resource for DLT run.

PearceR
New Contributor III

I had to scrap using DLT in the end for so many entities, the other option is to run in continuously but this is expensive.

-werners-
Esteemed Contributor III

Interesting...
DLT probably spends x seconds/table for the setup.
If you have time, you could do some tests to see if the table setup scales linearly (1 table, 5 sec for setup, 10 tables 50 sec etc).
If you do, please share the outcome.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.