You can run the below to get the size of the table in Bytes
spark.sql("describe detail delta-table-name").select("sizeInBytes").collect()