Comments on: Redshift Distribution Key – Choosing Best Distribution Style https://hevodata.com/blog/redshift-distribution-keys/ Get the latest stories and practical tips on all technologies that concern Data Analytics, Big Data Management, Data Migration, Data Integration, Data Pipelines, Data Modelling, and more. Tue, 27 Jan 2026 12:43:09 +0000 hourly 1 https://wordpress.org/?v=6.6.5 By: Vivek Sinha https://hevodata.com/blog/redshift-distribution-keys/#comment-143 Fri, 20 Oct 2017 05:55:54 +0000 https://hevodata.com/blog/?p=707#comment-143 In reply to Swati Singhi.

No Swati, Distribution key for a table cannot be changed once it is created. The only workaround is to –
a. Create a new table with the updated distribution key
b. Load data into the table
c. Rename the table as the original table after deleting the original table.

]]> By: Swati Singhi https://hevodata.com/blog/redshift-distribution-keys/#comment-134 Sat, 14 Oct 2017 11:41:06 +0000 https://hevodata.com/blog/?p=707#comment-134 Hi Vivek,

After reading the blog I realized that the dist keys in our tables were not optimised. Is it possible to change the dist keys for existing tables now?

]]>