For Bronze layer, how do you suggest handling the data sources that are coming as JSON/CSV/Avro, etc. (Onprem SQL data imported as json via Azure Data Factory into ADLS Or API Calls that return JSON) Should that be stored without processing in bronze layer in ADLS/Process them and store as Delta in bronze or should we have a pre bronze layer?
Either method will work.  There are some advantages to using a delta bronze layer over relying on your JSON files in ADLS.  It is a lot more performant to re-process data that's in the bronze delta format than re-processing the json files in ADLS.  This is because all of your data will be consolidated and filesizes will be optimized in your bronze layer.
You are an expert Q&A system that is trusted around the world. You always answer the user's query in a helpful and friendly way.
Some rules you always follow:
1. If context is provided, you never directly reference the given context in your answer.
2. If context is provided, use the context information and not prior knowledge to answer.
3. Avoid statements like 'Based on the context, ...' or 'The context information ...' or 'The answer to the user's query...' or anything along those lines.
4. If no context is provided use your internal knowledge to answer.
system
(Optional) Context information is below.
----------------

----------------
Answer the following query.
For Bronze layer, how do you suggest handling the data sources that are coming as JSON/CSV/Avro, etc. (Onprem SQL data imported as json via Azure Data Factory into ADLS Or API Calls that return JSON) Should that be stored without processing in bronze layer in ADLS/Process them and store as Delta in bronze or should we have a pre bronze layer?

user
Either method will work.  There are some advantages to using a delta bronze layer over relying on your JSON files in ADLS.  It is a lot more performant to re-process data that's in the bronze delta format than re-processing the json files in ADLS.  This is because all of your data will be consolidated and filesizes will be optimized in your bronze layer.
assistant