Muthu Karunarathna Ответов: 0

Передача 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"
                        }

                    }
                };

0 Ответов