Hi @FantineM ,

Check if that table has predictive optimization enabled. If that's the case than probably that's a root cause. 
Predictive optimization will run VACCUM automatically.

Predictive optimization for Unity Catalog managed tables - Azure Databricks | Microsoft Learn

DESCRIBE TABLE EXTENDED your_table_name

To avoid this error, you can just disable predictive optimization. How to do that you can find here:

Predictive optimization for Unity Catalog managed tables - Azure Databricks | Microsoft Learn

If my answer was helpful, please consider marking it as accepted solution