Forum Discussion

DennesTorres's avatar
DennesTorres
Power Participant
3 years ago

How to list Table Properties

Hi, A table can have multiple properties, such as the v-order optimization. Some statements related to these properties are explained on the link https://learn.microsoft.com/en-us/fabric/data-e...
data engineering
chetnachaudhari's avatar
chetnachaudhari
Advocate I
3 years ago

DennesTorres The traditional statement to see table properties is working fine from notebooks.

I just verified it using below code snippet

%%sql
SHOW TBLPROPERTIES dim_calendar
 
 
  • DennesTorres's avatar
    DennesTorres
    Power Participant
    3 years ago

    Hi,

    I just tried it again and it's not working. Maybe I'm doing something wrong? I get a simple syntax error as feedback


    Kind Regards,

    Dennes

    • DennesTorres's avatar
      DennesTorres
      Power Participant
      3 years ago

      Hi,

      After some more tests, I solved the problem of the SHOW statement, it was a silly mistake I did. %%sql only works if it's on the first line of the code block.

      However, the final intended result didn't work. I was looking for discovering if the table was created using vorder optimization or optimizewrite, I was sure some of the tables were created with these features, while others were not, but the SHOW TBLPROPERTIES never show these properties.

      What could I be doing wrong?

       

      Kind Regards,

       

      Dennes

      • chetnachaudhari's avatar
        chetnachaudhari
        Advocate I
        3 years ago

        You can check the value of particular property using following syntax

        %%sql
SHOW TBLPROPERTIES dim_calendar ('delta.parquet.vorder.enabled');

         

        Regards,
        Chetna