Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2022 09:51 PM
Hi @Alejandro Martinez :
I don't think we have any such command to get the statistics before vacuum and after vacuum.
Atleast I haven't come across any.
If you want to capture more details, may be you can write a function to capture the statistics as below.
Data files size:
Data files count:
Before:
var getDataFileSize = 0
val getDataFileCount = dbutils.fs.ls(<Your Table Path>").toList.size
dbutils.fs.ls(<Your Table Path>)
.foreach
{
file =>
getDataFileSize = getDataFileSize + file.size
}
After:
Repeat above
Lets see if other community members have better ideas on this.