The default retention threshold for the VACUUM command is 7 days. This setting ensures that files less than 7 days old are not deleted, safeguarding against the removal of files that might still be in use by ongoing operations. For more details, refer to the Databricks documentation.