- 新しい順
- 投票が多い順
- コメントが多い順
Hello Shiv,
The limit on maximum number of tables includes permanent tables, temporary tables, datashare tables, and materialized views. External tables are counted as temporary tables. Temporary tables include user-defined temporary tables and temporary tables created by Amazon Redshift during query processing or system maintenance. Views and system tables aren't included in this limit. https://docs.aws.amazon.com/redshift/latest/mgmt/amazon-redshift-limits.html
Work-around :-
I would suggest you to delete unnecessary local tables, this includes permanent and temporary tables or consider resizing to 4xlarge/8xlarge/16xlarge node type which can have a maximum of 100,000 tables.
https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_usage.html
Thank you !