Sentence similarity: Training failed when choosing File Validation Option to training SQL Server data.

[v-Hailishi]

System Information (please complete the following information):
Windows OS: Windows-11-Enterprise-22H2
ML.Net Model Builder 2022: 17.18.2.2411602 (Main Build)
Microsoft Visual Studio Enterprise: 2022(17.8.7)
.Net Core: 6.0,7.0,8.0

Describe the bug

• On which step of the process did you run into an issue:
  Training filed when choosing File Validation Option.

TestMatrix
https://github.com/dotnet/machinelearning-modelbuilder/files/10534387/home-depot-sentence-similarity-small.csv

To Reproduce
Steps to reproduce the behavior:

1. Select Create a new project from the Visual Studio start window.
2. Choose the C# Console App (.NET Core) project template.
3. Add model builder by right click on the project.
4. Select "Sentence similarity" scenario.
5. On the Data page, choose the SQL Server data source, then choosing File Validation Option on the "Advanced data options" dialog.
   
6. On the Train page, click "Start training" button, you will see that the training failed.

Expected behavior
Training successful.

Screenshot:

Additional context:
The bug is not repro when choosing Cross validation or Split validation option.

[zewditu]

@v-Hailishi , this is related with data formatting option in advanced data options, if you make allow quote set to yes it will work

It seems that we need to show specific error message or action the user should do.

[v-Hailishi]

@zewditu Sorry I am not clear the data source. I have updated the title and the repro steps. When training the SQL server data, it is not supporting the data formatting.

[zewditu]

Got it, thanks, the best fix is if the data source is SQL the default will be yes.

[zewditu]

Long term fix work item #2861

[v-Hailishi]

The bug has been fixed on the latest main build 17.18.2.2412201.