synapse analytics datastores from Azure ML

秋山 泉 1 Reputation point
2022-04-10T13:11:27.577+00:00

I use Azure ML (designer) as data mining pourpose.
AND use synapse for datapreparation.

After I executed data preparation prosess, i want to use the prepared data from Azure ML environment,,, but I can not select Azure Synapse data sourse from Azure ML side as datastores.

Is there any work around? Or you just do not support it?

https://learn.microsoft.com/en-us/azure/machine-learning/how-to-access-data

Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,558 questions
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,357 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. 秋山 泉 1 Reputation point
    2022-04-10T23:46:35.247+00:00

    Azure ML support SQL server as datastore.
    And Azure SQL support external table with which I can use Azure Synapse (serverless) external table.

    1. I created external table in Azure SQL with this blog...
      https://devblogs.microsoft.com/azure-sql/read-azure-storage-files-using-synapse-sql-external-tables/

    2.I attached Azure SQL as data store.

    Now I can use synapse serverless data in Azure ML directly....

    It would be much faster if Azure ML would support synapse data set as datastore, though....