0

I have a MLTable data asset in Azure ML studio that I am trying to access in python and I can't figure out the structure of the path.

My datastore name is fooddb and my MLTable name is food. The MLTable was created in Microsoft Azure Machine Learning Studio.

training_data_input  = Input(type=AssetTypes.MLTABLE, path="azureml://datastores/fooddb/paths/food")

timeseries_job = automl.forecasting(
    compute="compute",
    training_data=training_data_input,
    experiment_name="salesforecast",
    target_column_name="QTY",
    primary_metric="r2_score",
    n_cross_validations=5,
    enable_model_explainability=True,
    forecasting_settings=forecast_settings
)
Jamie
  • 1

2 Answers2

0

Go to azure portal

Create Azure Machine Learning Studio resource.

enter image description here

Create the Resource

enter image description here

Goto to Datastores

enter image description here

Click on New Datastore

enter image description here

Give complete details

enter image description here

The Account key will be generated in Storage account, that will be shown later.

enter image description here

enter image description here

enter image description here

Go to Storage account

Click on upload.

enter image description here Give the required details

enter image description here Dataset uploaded

enter image description here

The key details which we need to give in Datastore creation is from here

enter image description here

enter image description here

enter image description here Click Next

enter image description here

The Data URL is the files path in datastore that can be used as the external file path.

Sairam Tadepalli
  • 1,563
  • 1
  • 3
  • 11
0

To use an AzureML data (Table) asset in a job, you can pass in the asset id...

# get the data asset
data_asset = ml_client.data.get(name="<asset-name>", version="<version>")

training_data_input  = Input(type=AssetTypes.MLTABLE, path=data_asset.id)

timeseries_job = automl.forecasting(
    compute="compute",
    training_data=training_data_input,
    experiment_name="salesforecast",
    target_column_name="QTY",
    primary_metric="r2_score",
    n_cross_validations=5,
    enable_model_explainability=True,
    forecasting_settings=forecast_settings
)
Sam Kemp
  • 21
  • 2