Передача SQL-запроса в качестве глобального параметра в azure ML
I have my sales estimates model created withing Azure Ml and it has lot of data imports via on-premises SQL which also have few parameters changing each time. So I wanted to pass the import data queries as global parameters as it is easy when I work in get the results via console app(c#). But it doesn't work.When I test it on Ml studio it gives me timeout exception. But in console app it gives me "Task was cancelled" exception. I have included the code and screen shot below.
Что я уже пробовал:
using (var client = new HttpClient()) { var scoreRequest = new { Inputs = new Dictionary<string, List<Dictionary<string, string>>>() { { "InputVariables", new List<Dictionary<string, string>>() { new Dictionary<string, string>() { { "ID1", shop.ShopId }, { "ID2", shop.CompanyId }, { "DateAsOf", dateAsOf.ToString("yyyy-MM-dd") } } } }, }, GlobalParameters = new Dictionary<string, string>() { { "MonthlySalesData", " select ID1, ID2,time,value,shoppingcenterId from Sales.SalesAll_Monthly where id1=549" } } };