topic Delta live table blocks pipeline autoloader rate limit in Data Engineering

Delta live table blocks pipeline autoloader rate limit

Rdipak — Thu, 16 Nov 2023 12:29:56 GMT

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?

Re: Delta live table blocks pipeline autoloader rate limit

kulkpd — Fri, 17 Nov 2023 22:51:57 GMT

Did you try following options:

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

Re: Delta live table blocks pipeline autoloader rate limit

Rdipak — Fri, 17 Nov 2023 23:44:54 GMT

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?