how to find the size of a table in python or sql?

[ramankr48]

let's suppose there is a database db, inside that so many tables are there and , i want to get the size of tables . how to get in either sql, python, pyspark.

even if i have to get one by one it's fine.

[elgeo]

DESCRIBE DETAIL table_name returns the sizeInBytes

[youssefmrini]

Describe detail give you only the size of the latest snapshot. It's worth running a dbutils.fs.ls

[shan_chandra]

@Raman Gupta​ - Please refer to the below

Calculate the size of the Delta table:

%scala 
import com.databricks.sql.transaction.tahoe._
val deltaLog = DeltaLog.forTable(spark, "dbfs:/delta-table-path")
val snapshot = deltaLog.snapshot                     // the current delta table snapshot
println(s"Total file size (bytes): ${deltaLog.snapshot.sizeInBytes}"

calculate the size of the non delta table:

%scala
spark.read.table("non-delta-table-name").queryExecution.analyzed.stats

[ramankr48]

Already know in scala.

I wanted this in either python or sql

scala link: https://kb.databricks.com/sql/find-size-of-table.html#:~:text=To%20find%20the%20size%20of%20a%20delt...

[shan_chandra · Accepted solution]

@Raman Gupta​ - could you please try the below

%python
spark.sql("describe detail delta-table-name").select("sizeInBytes").collect()

[ramankr48]

Thanks @Shanmugavel Chandrakasu​