Hi @Retired_mod,
1- Regarding this issue i had found below link:
https://kb.databricks.com/sql/find-size-of-table#:~:text=You%20can%20determine%20the%20size,stats%20...
Now to try above link, I need to decide: Delta-Table Vs Non-Delta-Table.
Few of my tables are Materialized Views while some are Streaming Tables. So I am Not able to understand about which one to try: Delta-Table Vs Non-Delta-Table.
Can you please help me in that ?
2- Also in above link, for Delta-Table, for below line of code:
DeltaLog.forTable(spark, "dbfs:/<path-to-delta-table>")
I do Not know path: "dbfs:/<path-to-delta-table>".
From where I can get this path, UI Or Command ?
As i am working for corporate company, Admin have given only necessary (minimum) access. So if you guide me than I can ask Admin for permission.
3- When I opened your above given link and tried your solution, I got below error:
Cannot query a Streaming Table `DB`.`Schema`.`Table_append_raw` from an Assigned or No isolation shared cluster, please use a SHARED cluster or a Databricks SQL warehouse instead.
So from above I understood that we need to use SHARED cluster. Is there any other option we have ?
Thank you
Devsql