With our new Custom Persistence DDL feature, you can declare the custom_ddl for a Persistence, and customize how the persistence table is created in your Data Warehouse.
This allows you to apply Data Warehouse optimization features and techniques - such as indexing, clustering, applying SORTKEY, etc. - to improve the performance of your physically persisted tables!
You can learn about this feature in our docs here: Public Docs | Custom DDL.
If you have any feedback or questions, please share them on this Community Thread.