Share via

Azure ML Upload Data to Azure SQL without Data Factory and Data Transfer Step

Andreas Meier 1 Reputation point
2021-05-27T07:02:20.05+00:00

From the documentation I could find ways to read data from Azure SQL database registered as datastore in azureML,but not ways to upload or write output data to azure SQL database from azureML. Can anyone please guide me on the same?

Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
3,336 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ramr-msft 17,826 Reputation points
    2021-05-28T04:18:35.477+00:00

    @Andreas Meier Thanks for the question. Are you trying to upload data using AML Designer or AML python SDK?. You can upload data using upload_directory API.

    The OutputDatasetConfig allows even to register the output as a Dataset, where getting rid of such folder structure makes sense. From the docs itself: "Represent how to copy the output of a run and be promoted as a FileDataset. The OutputFileDatasetConfig allows you to specify how you want a particular local path on the compute target to be uploaded to the specified destination".

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.