Which tool or method do you use to load data into the silver layer from blob storage?

I typically use Azure Data Factory or Azure Synapse Pipelines to copy data from Azure Blob Storage into a silver layer. The pipeline can be scheduled or event‑driven, and it supports schema mapping, data type conversion, and incremental loads. For large JSON files, I often use Spark jobs in Databricks to read the blob, flatten the structure, and write the cleaned data to the silver layer in Parquet format.