Azure SQL Database
An Azure relational database service.
5,443 questions
An error received while deploying an ML model in Dedicated SQL pool
Ali Davoudian
61
Reputation points
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.
{count} votes
-
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee2022-04-04T10:11:05.873+00:00 Hello anonymous user,
Thanks for the question and using MS Q&A platform.
Could you please help me with the step at which you are facing this issue? Kindly share the screenshot of the error message.
-
Ali Davoudian 61 Reputation points
2022-04-04T11:45:39.657+00:00 Here is the screenshot: ![189723-1.jpg][1]![189704-2.jpg][2] [1]: /api/attachments/189723-1.jpg?platform=QnA [2]: /api/attachments/189704-2.jpg?platform=QnA
-
Ali Davoudian 61 Reputation points
2022-04-04T11:46:44.1+00:00 I attached the screenshots.
Many thanks
Ali -
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
2022-04-05T05:25:30.267+00:00 Hello anonymous user,
As per the dataset there is no column named ID. As per the document you are suppose to use fareAmount as the column.
You will then see a column mapping between the training and test data format (which should automatically match 1-to-1), and can see the model_output column, which in our case will be the
fareAmount. -
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
2022-04-07T09:57:37.133+00:00 Hello anonymous user,
Follow up to see if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.
-
Ali Davoudian 61 Reputation points
2022-04-07T10:59:07.343+00:00 Yes I checked It. But I did train the model for classification and I selected "Tip" as the target. But again I see the same error complaining about 'ID'!!!!
-
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
2022-04-13T07:41:49.61+00:00 Hello anonymous user,
This issue looks strange. For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket.
-
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
2022-04-18T05:42:39.093+00:00 Hello anonymous user,
Did you get a chance to open a support ticket?
Sign in to comment