For low code users, it would be awesome if there was a Data Pipeline activity that can be used to run Optimize on a table in a Lakehouse (or all tables in a Lakehouse).
For example, when using ...
KevinFeit
Advocate I
Advocate II agree with this. In addition to optimize, it should also have the option to vacuum. A big selling point of Fabric is that it makes things easy compared to other platforms, so this would be a great step in that direction. SQL Server has had maintenance plans going back at least to SQL Server 2005, I think. So giving Fabric a similar capability to schedule regular maintenance should be a no-brainer.
