synapse direct write to blob?

Question

synapse direct write to blob?

a1990 1

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?

Answer 1

HarithaMaddi-MSFT 10,086

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.

HarithaMaddi-MSFT 10,086 Reputation points

2020-11-30T06:48:52.637+00:00

Hi @a1990 ,

We have not received a response from you. Please suggest if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community member
HarithaMaddi-MSFT 10,086 Reputation points

2020-12-02T07:45:32.813+00:00

Hi @a1990 ,

We still have not heard back from you. Following up to check if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community member

synapse direct write to blob?

1 answer

Activity