Hi,
To cache large volumes of data and optimize the performance when caching, you could make use of the [Bulk Data Load](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/bulk_data_load/bulk_data_load) option. For more details, you can refer to the Optimizing Cache Load Processes section of [Best Practices to Maximize Performance III: Caching](https://www.google.com/url?q=https://community.denodo.com/kb/en/view/document/Best%2520Practices%2520to%2520Maximize%2520Performance%2520III%253A%2520Caching&sa=D&source=editors&ust=1622462036968000&usg=AOvVaw0EpFSDHhdiuWZHny0o9mJP) of the Knowledge Base article.
As of now, it is not possible to use the Azure Synapse’s CTAS functionality in the Denodo Platform. Also, by default Azure Synapse uses the distribution as [ROUND_ROBIN](https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehouse?view=aps-pdw-2016-au7#examples-for-table-distribution) and at the moment it is not possible to change the distribution from the Denodo Platform.
Hope this helps!
