There are instances where we need to know the individual file size or file count present in the delta table rather than the average size. we can use the below query to determine that.
%sql
select count(*) as rows, file_path, file_size from (select * , _metadata.file_path, _metadata.file_size from <table_name or delta.`file_path`>) group by file_path, file_size
