I'm trying to query a function in Azure Data Explorer using ADF. When I try to preview the data, I get the following error:
Error details
Error code: 11203
Details:
Read from Kusto failed with following error: Semantic error: Errors occurred while resolving remote entities.
Database='DB1': Access denied. Query: 'FunctionNameinDB2() | take 10'. Query: FunctionNameinDB2() | take 10. Semantic error: Errors occurred while resolving remote entities. Database='DB1': Access denied. Query: 'FunctionNameinDB2() | take 10' Activity ID: <guid>
The problem is that the function I'm querying isn't in DB1, it's in DB2. I've tried running other functions in other databases within the same Kusto cluster, and they work just fine!
Here's my (obfuscated) JSON for both the linked service and the dataset. Any thoughts?
Linked Service:
{
"name": "LinkedServiceName",
"properties": {
"description": "https://clustercontainingDB1andDB2.kusto.windows.net",
"annotations": [],
"type": "AzureDataExplorer",
"typeProperties": {
"endpoint": "https://clustercontainingDB1andDB2.kusto.windows.net",
"tenant": "<tenant_guid>",
"servicePrincipalId": "<spn_guid>",
"servicePrincipalKey": {
"type": "AzureKeyVaultSecret",
"store": {
"referenceName": "AKVName",
"type": "LinkedServiceReference"
},
"secretName": "secretname"
},
"database": "DB2"
},
"connectVia": {
"referenceName": "AutoResolveIntegrationRuntime",
"type": "IntegrationRuntimeReference"
}
}
}
Dataset:
{
"name": "DatesetName",
"properties": {
"linkedServiceName": {
"referenceName": "LinkedServiceName",
"type": "LinkedServiceReference"
},
"annotations": [],
"type": "AzureDataExplorerTable",
"schema": [],
"typeProperties": {
"table": "FunctionNameinDB2()"
}
}
}