Forum Discussion

madinugraha's avatar
madinugraha
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago
Solved

Size table in workspace

Hi, One of my customer asking how to identify size of table in the workspace ID of Fabric.   They already tried to use powershell and onelake explorer, but haven't got any luck   Perhaps anyone c...
workspaces
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi madinugraha ,
    The difference between workspace size reported in the Microsoft Fabric Capacity Metrics app (around 400 GB) and the actual sizes of the warehouse tables you've queried is because:

    The total workspace size includes more than just the raw data from warehouse tables. It includes all data assets within your workspace such as:

    • Datasets

    • Dataflows

    • Reports

    • Models

    • Temporary files

    • Caches

    • Log files

    • Metadata and indexes

    Additionally, temporary data, intermediate storage, and version histories contribute to the overall workspace size.

    Billable Storage vs. Current Storage:

    You might have noticed terms like "current storage" and "billable storage" in the Fabric Capacity Metrics app:

    • Billable Storage : Represents the storage being billed based on usage at the start of the reporting period. It may be lower if the storage usage was less at that start.

    • Current Storage : Reflects real-time storage usage, including all current data assets, caches, and temporary files. This can be dynamic and change more frequently.

    For detailed information please refer the following link:
    metrics-app-storage-page 

    I hope this clarifies the situation. Please let me know if you have any further questions!

    If this post helps, please accept as solution to help others find easily.

    Best regards,
    Vinay.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi madinugraha ,
Thanks for using Microsoft Fabric Community Forum to post your question.
To get the size of tables in Fabric Warehouse, the SQL query provided by NandanHegde should work.
You can also modify the query to get the size in MB or KB.
If size needed for only a specific table, replace WHERE clause with the following:

WHERE
    t.is_ms_shipped = 0
    AND i.object_id > 255
    AND t.NAME = 'Table Name'

Hope it works. If any further assistance needed please reach out.
If this post helps please accept whichever solution met your query and a Kudos would be appreciated.

Best Regards,
Vinay.



  • madinugraha's avatar
    madinugraha
    Icon for Microsoft Employee rankMicrosoft Employee
    1 year ago

    Hi

     

    My customer tried the query and it works to describe the table. But the question is that from the workspace size is almost 400GB (please find the ss as below), but when he do the query, he can see all of the size each table, but it doesn't representing the size of 400GB from the workspace. May I know how why it's not correlated?

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi madinugraha ,
      The difference between workspace size reported in the Microsoft Fabric Capacity Metrics app (around 400 GB) and the actual sizes of the warehouse tables you've queried is because:

      The total workspace size includes more than just the raw data from warehouse tables. It includes all data assets within your workspace such as:

      • Datasets

      • Dataflows

      • Reports

      • Models

      • Temporary files

      • Caches

      • Log files

      • Metadata and indexes

      Additionally, temporary data, intermediate storage, and version histories contribute to the overall workspace size.

      Billable Storage vs. Current Storage:

      You might have noticed terms like "current storage" and "billable storage" in the Fabric Capacity Metrics app:

      • Billable Storage : Represents the storage being billed based on usage at the start of the reporting period. It may be lower if the storage usage was less at that start.

      • Current Storage : Reflects real-time storage usage, including all current data assets, caches, and temporary files. This can be dynamic and change more frequently.

      For detailed information please refer the following link:
      metrics-app-storage-page 

      I hope this clarifies the situation. Please let me know if you have any further questions!

      If this post helps, please accept as solution to help others find easily.

      Best regards,
      Vinay.