You can translate the question and the replies:

Denodo Cache load - Can I use CTAS in Azure Synapse?

We have been having issues with Denodo creating cache tables due to volume and intensive queries. Is it possible to use Azure Synapse's CTAS functionality? Also, Denodo creates a table with Round Robin distribution, would it be possible to change it to Hash?
25-05-2021 17:16:02 -0400

1 Answer

Hi, To cache large volumes of data and optimize the performance when caching, you could make use of the [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]( 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]( and at the moment it is not possible to change the distribution from the Denodo Platform. Hope this helps!
Denodo Team
31-05-2021 07:15:30 -0400
You must sign in to add an answer. If you do not have an account, you can register here