Forum Discussion

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

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

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
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
  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
  - DennesTorres
    Power Participant
    3 years ago
    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