Export Data module

This article describes a module in Azure Machine Learning designer.

Use this module to save results, intermediate data, and working data from your pipelines into cloud storage destinations.

This module supports exporting your data to the following cloud data services:

  • Azure Blob Container
  • Azure File Share
  • Azure Data Lake Storage Gen1
  • Azure Data Lake Storage Gen2
  • Azure SQL database

Before exporting your data, you need to first register a datastore in your Azure Machine Learning workspace. For more information, see Access data in Azure storage services.

How to configure Export Data

  1. Add the Export Data module to your pipeline in the designer. You can find this module in the Input and Output category.

  2. Connect Export Data to the module that contains the data you want to export.

  3. Select Export Data to open the Properties pane.

  4. For Datastore, select an existing datastore from the dropdown list. You can also create a new datastore. Check how by visiting Access data in Azure storage services.

    Note

    Exporting data of a certain data type to a SQL database column specified as another data type is not supported. The target table does not need to exist first.

  5. The checkbox, Regenerate output, decides whether to execute the module to regenerate output at running time.

    It's by default unselected, which means if the module has been executed with the same parameters previously, the system will reuse the output from last run to reduce run time.

    If it is selected, the system will execute the module again to regenerate output.

  6. Define the path in the datastore where the data is. The path is a relative path.Take data/testoutput as an example, which means the input data of Export Data will be exported to data/testoutput in the datastore you set in the Output settings of the module.

    Note

    The empty paths or URL paths are not allowed.

  7. For File format, select the format in which data should be stored.

  8. Submit the pipeline.

Limitations

Due to datstore access limitation, if your inference pipeline contains Export Data module, it will be auto-removed when deploy to real-time endpoint.

Next steps

See the set of modules available to Azure Machine Learning.