Amazon Redshift – CREATE TABLE Restrictions

Posted on by

Amazon Redshift enforces the following maximum limit for table:

  • Maximum 9,900 permanent tables per cluster.
  • Table name can be maximum 127 characters.
  • A table can have maximum 1600 columns.



This entry was posted in Amazon Redshift, Redshift Database Development and tagged by Khorshed. Bookmark the permalink.

About Khorshed

Khorshed has 12 years of cumulative professional experience in areas of database administration, development, Business Intelligent, system appreciation, requirement analysis and software development (using .net technologies). Achieved MCITP in SQL Server in both SQL Server development and administration. He has vast knowledge in SQL Server, SSIS, SSRS, SSAS. He is also proficient in Amazon cloud services like Redshift, Data Pipeline, SNS, DynamoDB, EMR and many more.

2 thoughts on “Amazon Redshift – CREATE TABLE Restrictions”

Leave a Reply

Your email address will not be published. Required fields are marked *