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.
You can export data from SQL Server 2016 to Azure Blob using PolyBase by creating an external table and running an insert into statement.