topic How to calculate the individual file count, file size and number of rows on a Delta table? in Data Engineering https://community.databricks.com/t5/data-engineering/how-to-calculate-the-individual-file-count-file-size-and-number/m-p/83842#M37030 <P>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.&nbsp;</P><LI-CODE lang="markup">%sql select count(*) as rows, file_path, file_size from (select * , _metadata.file_path, _metadata.file_size from &lt;table_name or delta.`file_path`&gt;) group by file_path, file_size</LI-CODE><P>&nbsp;</P> Wed, 21 Aug 2024 19:18:12 GMT shan_chandra 2024-08-21T19:18:12Z How to calculate the individual file count, file size and number of rows on a Delta table? https://community.databricks.com/t5/data-engineering/how-to-calculate-the-individual-file-count-file-size-and-number/m-p/83842#M37030 <P>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.&nbsp;</P><LI-CODE lang="markup">%sql select count(*) as rows, file_path, file_size from (select * , _metadata.file_path, _metadata.file_size from &lt;table_name or delta.`file_path`&gt;) group by file_path, file_size</LI-CODE><P>&nbsp;</P> Wed, 21 Aug 2024 19:18:12 GMT https://community.databricks.com/t5/data-engineering/how-to-calculate-the-individual-file-count-file-size-and-number/m-p/83842#M37030 shan_chandra 2024-08-21T19:18:12Z