Comparing SELECT..INTO and CTAS use cases in Azure SQL Data Warehouse
Azure SQL Data Warehouse users now have two options for creating and populating a table in a single statement. The first option is to use CREATE TABLE AS SELECT or CTAS. The second is to use SELECT..INTO.