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

Delta live table blocks pipeline autoloader rate limit

Rdipak
New Contributor II

I have created a ETL pipeline with DLT. My first step is to ingest into raw delta table using autoloader file notification. 
when I have 20k notification pipe line run well across all stages. But when we have surge in number of messages pipeline waits for first step to complete before processing next steps. 
this is strange considering my first step is a streaming delta table and next steps has dependency on this. 
question: is it possible to use rate limit with autoloader file notification implementation? 

2 REPLIES 2

kulkpd
Contributor

Did you try following options:

.option('cloudFiles.maxFilesPerTrigger', 10000) or maxBytesPerTrigger ?

Rdipak
New Contributor II

yep set it to 15K. Does these impact when running using file notification?

I am looking at parallel fetch whats the upper limit for this?

How to derive this number, is it based on number of workers, executors or cores?

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.