You are asked to enrich a customer dataset in your lakehouse by adding a new column that calculates the total purchase amount for each customer. Describe the steps you would take to achieve this, including any necessary data transformations and the method of adding the new column.

Simulated

Explanation:

Option B is the efficient and scalable approach. Using a SQL query to aggregate purchase amounts and add the new column ensures accuracy and can be easily updated as new data is ingested.