Forum Discussion
QUESTION::LAKEHOUSE::SQL ENDPOINT::SYSTEM VIEWS
Hi Element115 ,
Run the following two commands in Notebook to calculate the table size in lakehouse.
The first command contains the table size in byte, my table is smaller, replace the products table with your own when using it.
%%sql DESCRIBE DETAIL delta.`Tables/products`The second command converts byte to GB, replacing 3213 with your own after running the first command.
size_in_bytes = 3213 # byte swtich GB size_in_gb = size_in_bytes / (1024 ** 3) print(f “Table ‘products’ size: {size_in_gb:.8f} GB”)Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi Element115 ,
I can reproduce your error.
Some views in sys work fine.
These views are typically part of the system catalog and are intended to provide metadata about database objects.
In the case of a Trial license in Fabric, some views and features may be limited or not fully supported. There may be several reasons for this:
The Trial version may not include all of the functionality found in the full version, which may limit access to certain system views.
Although views are publicly available, query privileges may be restricted to ensure security and data integrity.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!