- 최신
- 최다 투표
- 가장 많은 댓글
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 !