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 * ...