An error received while deploying an ML model in Dedicated SQL pool

Ali Davoudian 61 Reputation points
2022-04-03T19:25:22.953+00:00

Hi,

I have followed the instructions in the following link to use AutoML in Azure ML for creating a classification ML model and then loading it into Dedicated SQL pool for prediction.
https://github.com/iuliaferoli/synapse_aml

But when loading the model into the Dedicated SQL pool (in the Synapse environment) I receive the following error!


Failed to deploy the model
An error occurred while deploying the model to "dbo.nyc_taxi". Error: Failed to execute query. Error: Invalid column name 'ID'.


I have no column named 'ID' !!!!

Many thanks of any reply.

Azure SQL Database
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,558 questions
{count} votes