Hi @saurabh18cs ,

Since Auto Loader with file notification mode uses Azure Storage Queue hence it is subject to the limitations related to Storage Queue. Below you can find them:

Scalability and performance targets for Queue Storage - Azure Storage | Microsoft Learn

From my experiance queues scale really well, but you need to test it on your environment