(2.7 and later ver) display uuid: show create mv settings show_uuid=1; https://demo.timeplus.cloud/ksql-alt/console/query?sql=show+create+order_events_table+settings+show_uuid%3D1 (2.9 later) display placement info: show create test settings verbose=true;