Forum Discussion
How to list Table Properties
You can check the value of particular property using following syntax
%%sql
SHOW TBLPROPERTIES dim_calendar ('delta.parquet.vorder.enabled');
Regards,
Chetna
Hi,
I tried as well. It always result that the table doesn't have this property.
I tried to drop and create the table again, in many different ways. I followed the guidance on https://learn.microsoft.com/en-us/fabric/data-engineering/delta-optimization-and-v-order?tabs=sparksql.
All my attempts always result in "The table doesn't have this property".
One of my last attempts was this:
Kind Regards,
Dennes
Yes, it is bit unclear on how it picks the tblproperties, I tried few ways they didn't show the property value, when I tried below it works
cheers,
ChetnaHi,!
Very interesting. I will need to investigate more. After all, this involves the v-order optimization of the files and if it doesn't work in some ways, there are more than one Microsoft tutorial with bad mistakes.
Thank you!
Kind Regards,
Dennes