Azure SQL Data Warehouse has limits on the maximum size of a transaction (as documented here). As CTAS operations cannot be performed inside a transaction, I was wondering if these limits still applied?
Azure SQL Data Warehouse – Transaction Limits for CTAS Operations
azure-sql-data-warehouse
Best Answer
Ref: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-develop-best-practices-transactions
The transaction safety limits only apply to fully logged operations.
CTAS
is capable of being minimally logged. So answer depends, ifCTAS
is minimally logged safety limit does not apply and vice versa.