cancel
Showing results for 
Search instead for 
Did you mean: 
Community Platform Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results for 
Search instead for 
Did you mean: 

Stream processing large number of JSON files and handling exception

VijayP
New Contributor
  1. application writes several JSON  (small)  files and the expected volumes of these files are high ( Estimate: 1 million during the peak season in a hourly window) . As per current design, these files are streamed through Spark Stream and we use autoloader to load these files. 
    1. Can Databricks bronze Job handle the volume without any failures loading to Bronze table. ?
    2. Reading several forms appears streaming a large parquet file is not ideal .
  2. Handling Stream Processing failures through quarantine process
    1. Any exception occurring we would like to write those records for operation’s review. Are there any best practices / reference material with example for handling the same?
1 REPLY 1

cgrant
Databricks Employee
Databricks Employee

We have customers that read millions of files per hour+ using Databricks Auto Loader. For high-volume use cases, we recommend enabling file notification mode, which, instead of continuously performing list operations on the filesystem, uses cloud native offerings to "push" new file locations to Auto Loader.

For handling bad records, we have the rescuedDataColumn and for JSON files in particular, columnNameOfCorruptRecord. You can use these in tandem with some additional filtering logic to quarantine bad records away.

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