Azure Data Explorer Command block does not show parameters for parametrized linked service

Oleh Yermokhin 21

I have parametrised linked service for Azure Data Explorer. The json looks like this:

{  
    "properties": {  
        "type": "AzureDataExplorer",  
        "parameters": {  
            "AzureDataExplorerClusterUrl": {  
                "type": "String",  
                "defaultValue": ""  
            },  
            "AzureDataExplorerDatabaseName": {  
                "type": "String",  
                "defaultValue": ""  
            }  
        },  
        "annotations": [],  
        "typeProperties": {  
            "endpoint": "@{linkedService().AzureDataExplorerClusterUrl}",  
            "database": "@{linkedService().AzureDataExplorerDatabaseName}"  
        }  
    }  
}

This works good with copy activity block and parameters input looks ok:

But when Azure Data Explorer Command block is used, there is not inputs for these parameters:

So the command will be executed always with defaults values of these parameters. This looks like a bug.

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-07-30T09:42:12.96+00:00

Hi @Oleh Yermokhin ,

Welcome to Microsoft Q&A Platform. Thank you for posting your query here.

It looks like your dataset is parameterized, not linked service.

In Copy activity image all the parameters what you mentioned are actually coming from your dataset, not from linked service. Also, it seems that json which you shared is actually from your dataset.

Could you please share your linked service screenshot and json? you can navigate to Managementhub menu and under linked services you can spot your linked service.

Please Note, Azure Data explorer linked service cannot be parameterize at this moment.
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-08-02T04:06:40.73+00:00

Hi @Oleh Yermokhin ,

Did you get chance to check my above comment and share requested details?

Oleh Yermokhin 21

Hi @ShaikMaheer-MSFT !

Sorry for the delay.

You are right that in the copy activity this parameters are from the dataset. I made another screenshot from the dataset where you can see that in the dataset there are
parameters from linked service.

Please find json below:

{  
    "properties": {  
        "type": "AzureDataExplorer",  
        "parameters": {  
            "AzureDataExplorerClusterUrl": {  
                "type": "String",  
                "defaultValue": "xxxx"  
            },  
            "AzureDataExplorerDatabaseName": {  
                "type": "String",  
                "defaultValue": "xxx"  
            }  
        },  
        "annotations": [],  
        "typeProperties": {  
            "endpoint": "@{linkedService().AzureDataExplorerClusterUrl}",  
            "database": "@{linkedService().AzureDataExplorerDatabaseName}"  
        }  
    }  
}

Accepted answer

Vaibhav Chaudhari 38,616 Reputation points

2021-07-30T05:47:20.953+00:00

Have you tried providing parameters in the Command section?

Reference - https://learn.microsoft.com/en-us/azure/data-explorer/data-factory-command-activity

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Please sign in to rate this answer.
Oleh Yermokhin 21 Reputation points

2021-08-02T06:35:13.623+00:00

Hi anonymous userChaudhari!

Thank you a lot for your answer! I know that there is a possibility to provide a database name in the command section, but I did not know that you can also provide a cluster url.
'I also have found following solution that I'm testing currently - https://sonamagrawal.medium.com/connect-azure-data-explorer-using-a-dynamic-selection-of-database-from-azure-data-factory-c686125107b2
Sign in to comment

Azure Data Explorer Command block does not show parameters for parametrized linked service

0 additional answers