https://community.databricks.com/t5/data-engineering/why-am-i-not-able-to-view-all-table-properties/m-p/3954#M821 <P>We have a live streaming table created using the command</P><PRE><CODE>CREATE OR REFRESH STREAMING LIVE TABLE foo TBLPROPERTIES ( "pipelines.autoOptimize.zOrderCols" = "c1,, c2, c3, c4", "delta.randomizeFilePrefixes" = "true" );</CODE></PRE><P>But when I run the show table properties command I just get this one property (which is not set in the first place)</P><PRE><CODE>show tblproperties foo key value transient_lastDdlTime 1684920718</CODE></PRE><P>Why am I not able to see the zOrder and randomizeFilePrefixes properties of the table?</P> Sat, 27 May 2023 04:28:33 GMT qwerty1 2023-05-27T04:28:33Z https://community.databricks.com/t5/data-engineering/why-am-i-not-able-to-view-all-table-properties/m-p/3954#M821 <P>We have a live streaming table created using the command</P><PRE><CODE>CREATE OR REFRESH STREAMING LIVE TABLE foo TBLPROPERTIES ( "pipelines.autoOptimize.zOrderCols" = "c1,, c2, c3, c4", "delta.randomizeFilePrefixes" = "true" );</CODE></PRE><P>But when I run the show table properties command I just get this one property (which is not set in the first place)</P><PRE><CODE>show tblproperties foo key value transient_lastDdlTime 1684920718</CODE></PRE><P>Why am I not able to see the zOrder and randomizeFilePrefixes properties of the table?</P> Sat, 27 May 2023 04:28:33 GMT https://community.databricks.com/t5/data-engineering/why-am-i-not-able-to-view-all-table-properties/m-p/3954#M821 qwerty1 2023-05-27T04:28:33Z