Andy Brownsword loads some data:
For this example I’ll use NHS monthly prescribing data which provides us with a large CSV, and we’ll copy it into a Lakehouse. For the Bronze layer we want to retain data as close to source as possible, so simply retrieving the file and retaining the CSV is the goal.
I’ll compare the options for this specific use case, with multiple runs for each. So, let’s see how the options stack up.
Click through to see how long each of the four options takes and what Andy recommends.