Question: how to define custom Model in Designer
In Azure ML Designer, I can't figure out how to define a custom Model. The builtin NN Regression module has many bugs (will open a separate issue for those), so I need to make my own custom model. The closest thing I've found so far is Create Python…
Question: what framework/language does Designer use behind the scenes?
I'm using Azure ML Designer, but it isn't clear what framework/language is being used behind the scenes. For example, deep learning is incredibly computation-heavy, so I would like to run any matrix multiplications on a GPU instead of on a CPU. For the…
Unknown Host when connecting to MySQL Azure from Azure VM in PHP
I have an Azure Windows Server 2016 VM and a database hosted in MySQL Azure. I have the connection information from the Azure portal, and can connect to the database from MySQL workbench on the VM, as well as through powershell. However, I'm struggling…
Can not perform requested operation on nested resource. Parent resource not found
Hi, When I tried to use az SQL import, I'm getting the following error, what might be the cause and solution for this? I went through this https://learn.microsoft.com/en-us/azure/azure-resource-manager/templates/error-parent-resource but…
Error when using Alternate Key in CDS connector
I'm using the Common Data Service for Apps connector in Azure Data Factory to load data into Dynamics 365 I've done this successfully before using the entity key. See this question:…
Why Function App behaves differently on VS Code and Azure Portal
Hi team Az Functions. I have a Function app in TS that shows two different results. Image on the left is on Azure Portal. Image on the right is VS Code. Both running on the same Node v12 runtime but the portal can't detect the strings with special…
Azure portal cosmos db page layout problem
Hello, this morning i have gone into the azure portal for viewing the contents of cosmos db containers. There now appears to be a large blank panel on the right of the screen which means that the area for viewing the data is now squashed to a few…
resolve merge conflicts data factory in dev ops
Hi All, I have a Data Factory V2 which i have connected to Azure DevOps git. I inadvertently edited the master branch then went back to my feature branch to do some more development. When I go to create a pull request to go into master I get a merge…
Please provide a list of specific IP ranges azure webJobs use
Hi Experts, We have requirement to push data from azure webJob to a server within out datacenter. Hence we would like to know the specific set of IP Ranges Azure WebJobs use so that we can whitelist at the internal server.
Real-time endpoint response is empty
Hi, I've created and deployed NLP pipeline as a real-time endpoint, but the response that I get is an empty result ( {"Results":{}} ) with Status 200 OK. I have the Owner role, so i think that the permission is not a problem. I've also…
How to summarize sentiment for a long text with Text Analytics sentiment API?
With Azure Text Analytics sentiment API, we're able to label sentiment for a text piece. However, for a long piece of text that exceeds the 5120 limit, we have to split it into chunks. My question is after getting the sentiment labels for individual…
DNS resolution not working for some CNAMEs
I have several Windows 2016 domain controllers running DNS for my organisation. Each is configured with a forwarder to dns.google for non-local zones. For the most part, they work fine. However we have seen a few cnames which dont resolve correctly.…
What does it mean when Test-NetConnection gives both "Status: TimeOut" and "TcpTestSucceeded : True"?
I am so friggin confused. I'm trying to use Azure file storage on a windows server and Test-NetConnection gives both "Status: TimeOut" and "TcpTestSucceeded : True". Can anyone explain what this means? PS…
How do I lookup a description for a value from input source file in Azure Data Factory?
Hi, I'm still very new to Azure Data Factory and thusfar have only used the copy activity using input from blob storage and writing to Azure SQL Database. Now I have a situation where I have in input .csv file with 4 fields from blob storage. 3 of…
How we can manage multiple DB for different customers using single SQL server hosted in Azure ..? Can anyone suggest a better solution for this ..?
Our aim is to reduce the SQL server licensing and hardware cost also for the high availability of the servers.
Cosmos DB Migration Tool - SQL Database to Cosmos DB
Hi there, I have data saved in SQL Database, which I'm migrating. I used to save Lat and Lon into a separate column, but for the new implementation, I'm saving lat and lon as GeoJSON point. While migration, I want to save Lat and Lon as GeoJSON on…
Data migration to Azure data lake using sas failes suddenly
HI , i have a process which is copying data to azure data lake using sas key. from 27th june 2020 around 4:00 am ust it stopeed suddenly giving error message "java.util.NoSuchElementException: An error occurred while enumerating the result, check…
Azure Data Factory: Flattening/normalizing a cloumn from CSV file using Azure Data Factory activity
HI, I have pulled a csv file from one of our source using ADF and there is one column called "attributes" which contains multiple fields (in the form of key value pairs). Now I want to expand that column into different fields (columns). Below…
How can I connect Azure Data Factory to SFTP server using ssh authentication
We are slowly moving all our ETL to ADF. We have few SFTP servers and we would like to connect those SFTP servers from ADF. Can someone shed some light on SSH key authentication between ADF and SFTP. Thanks in Advance Nikhil
Processing Azure Data Factory Event Trigger Properties
I have a data factory which triggers based on storage blob event. In the triggered event, I see two properties TriggerTime and EventPayload. As I have need to read the Storage Blob related information I am trying to process the EventPayload in the Data…