You need to enrich a product dataset in your lakehouse by adding a new column that categorizes products based on their sales volume. Describe the steps you would take to achieve this, including any necessary data transformations and the method of adding the new column.