In a lakehouse I have a series of raw tables imported from Snowflake. I want to transform these tables using SQL language to store them in table format in a warehouse. What would be the optimal process for this function? One option I have considered is to create a view in the lakehouse and use a dataflow to take it to the warehouse, but I don't know if this is the most optimal solution.