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.