Uncategorized, sql-data-warehouse
Published • 2 min read
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. This post summarises the differences between the two approaches.