synapse direct write to blob?

a1990 11 Reputation points
2020-11-27T10:59:54.407+00:00

Through external table or copy into command we can copy the files blob data into synapse. is there any way to export/write back table data to blob using native synapse command rather than data factory?

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,557 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-11-27T14:37:10.103+00:00

    Hi @a1990 ,

    Welcome to Microsoft Q&A Platform. Thanks for posting the query.

    Below is an approach to achieve the same. Please find this reference MS document for various approaches.

    • Using BCP/SQLCMD to export data into a local file
    • Using AzCopy to copy the file into blob storage

    Please suggest for further queries and we will be glad to assist.

    ---

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.