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: 

Delta Live Tables: How does it identify new files?

dbuschi
New Contributor II

Hi,
I'm importing large numbers of parquet files (ca 5200 files per day, they each land in a separate folder) into Azure ADLS storage.
I have a DLT streaming table reading from the root folder.
I noticed a massive spike in storage account costs due to file system reads.
Questions: How does DLT identify newly arriving files? Does it always have to monitor the entire folder including all historical files?
Are there any design patterns to resolve this (i.e regarding folder structure, archiving of processed files)?
Many thanks for your help!

1 ACCEPTED SOLUTION

Accepted Solutions

SparkJun
Databricks Employee
Databricks Employee

Please refer to the autoloader for details https://learn.microsoft.com/en-us/azure/databricks/ingestion/cloud-object-storage/auto-loader/ You can use autoloader in DLT to detect new files. Our document also mentions the file name patterns that work with the autoloader. 

View solution in original post

2 REPLIES 2

SparkJun
Databricks Employee
Databricks Employee

Please refer to the autoloader for details https://learn.microsoft.com/en-us/azure/databricks/ingestion/cloud-object-storage/auto-loader/ You can use autoloader in DLT to detect new files. Our document also mentions the file name patterns that work with the autoloader. 

dbuschi
New Contributor II

To resolve the issue of excessive directory scanning, I have changed the folder structure to separate historical files from current files and reduce the number of folders and files that the Databrick process monitors.

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