Explanation To ensure the loading user has enough memory to achieve maximum compression rates, use loading users that are a member of a medium or large resource class. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/guidance-for-loading-data