Search code examples
sql-serverazure-sql-databasepolybase

Why can't Microsoft implement CETAS export for SQL Server 2016?


I wanted to export some data directly from SQL Server to Azure Blob storage in compressed orc format but there doesn't seem to be a way export like Azure SQL DW using CETAS Statement? I am wondering why Microsoft didn't include this feature in SQL Server 2016.


Solution

  • You can export data from SQL Server 2016 to Azure Blob using PolyBase by creating an external table and running an insert into statement.