![]() The quota violation occurrence is stored in the system table stl_schema_quota_violations. When a transaction exceeds the quota, Amazon Redshift aborts the transaction, prohibits subsequent ingestions, and reverts all changes until you free up disk space. That’s why you initially see the message loading to table lineitem completed successfully. The size limit can exceed the quota temporarily within a transaction before it’s committed because the quota violation check occurs at the end of a transaction. INFO: Load into table 'lineitem' completed, 59986052 record(s) loaded successfully.ĮRROR: Transaction 40895 is aborted due to exceeding the disk space quota in schema(s): (Schema: sales_schema, Quota: 2048, Current Disk Usage: 2798).įree up disk space or request increased quota for the schema(s).Īmazon Redshift checks each transaction for quota violations before committing the transaction.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |