I have a requirement to replay ingestion from landing data and build silver table. I am trying to write delta file from raw Avro files based in landing zone. The raw files are located in folder based on date. I am currently using streaming to read data from files and write into delta file with Z order.
Issue is that it is taking 8-10 hours for for each day[around 20 million records]. Any pointers on how may I can improve performance ?
Few I can think of are:
I can use batch read instead of stream?
Use Parquet instead of Delta ?
Any other?
Thanks in advance for kind help