Deploy ADX tables ,fucntions and mapping from NonProd to Prod using Kusto Command task in Azure DevOPS

DataEngineer 40 Reputation points
2024-03-12T11:55:51.11+00:00

I have a Azure Pipeline for deploying ADX tables and Functions using Kusto command task , how ever when I try deploying I am getting this weird error

2024-03-12T11:47:23.2165596Z ##[error]Service returned an error: Error: getaddrinfo ENOTFOUND adx.kusto.windows.net adx.kusto.windows.net:443 ran location from GitTables/DEMO.csl server: adx.kusto.windows.net database: Enriched command: .create-merge table DEMO (['time']:datetime)"

I am trying to follow this tutorial https://medium.com/@openthescreen/streamlining-azure-data-explorer-table-creation-mapping-and-functions-with-azure-devops-pipeline-dc83b86ffee1

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
482 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2024-03-13T10:03:32.9666667+00:00

    Hi DataEngineer,

    The error message you are seeing indicates that the Kusto command task in your Azure Pipeline is unable to resolve the hostname for your Azure Data Explorer cluster. This could be due to a few different reasons, such as a DNS issue or a misconfiguration in your pipeline.

    Here are some steps you can take to troubleshoot and resolve this issue:

    Check the hostname for your Azure Data Explorer cluster to ensure that it is correct. You can find the hostname in the Azure portal under the "Overview" tab for your cluster.

    Check the DNS settings for your Azure Pipeline to ensure that it is able to resolve the hostname for your Azure Data Explorer cluster. You can do this by running the following command in a command prompt or terminal window:

    nslookup adx.kusto.windows.net

    This command will show you the IP address associated with the hostname for your Azure Data Explorer cluster. If the command is unable to resolve the hostname, there may be an issue with your DNS settings.

    Check the firewall settings for your Azure Data Explorer cluster to ensure that they are properly configured to allow traffic from your Azure Pipeline. You can do this by going to the Azure portal, navigating to your Azure Data Explorer cluster, and checking the firewall settings under the "Security + networking" tab.

    Check the configuration of your Kusto command task in your Azure Pipeline to ensure that it is properly configured to connect to your Azure Data Explorer cluster. Make sure that the server and database names are correct and that the command is properly formatted.

    If none of the above steps resolve the issue, consider opening a support ticket with Microsoft to get further assistance.

    I hope this helps you resolve the issue and successfully deploy your ADX tables and functions using your Azure Pipeline.