Enable Interactive Authoring Under Managed Virtual Network in Azure ADF pipeline

Dinesh Prajapati 126 Reputation points
2023-03-07T05:11:01.63+00:00

Enable Interactive Authoring Under Managed Virtual Network in Azure ADF pipeline.

I have a requirement wherein I have to enable the interactive authoring option under Managed Virtual Network in Azure ADF pipeline via AzureCLI/Azure Powershell or any other SDK.
It should first check the status of Interactive Authoring and if the status is disabled then it should enable it.

Could you please help me on this

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,334 questions
{count} votes

2 answers

Sort by: Most helpful
  1. MartinJaffer-MSFT 26,011 Reputation points
    2023-03-24T21:16:27.4633333+00:00

    @Dinesh Prajapati Hello and welcome to Microsoft Q&A.

    I understand you wish to monitor and enable the "Interactive Authoring" feature in Data Factory.

    Even if this is possible, I don't think it is advisable. Interactive Authoring features are for when someone is working on the Factory. Keeping it active while the engineer sleeps does not help.

    Since the api for interactive authoring is not part of the user documentation, it is not a supported scenario. Given the browser makes the call to enable interactive authoring, it is theoretically possible for you to do as well. 'Not supported' means I can't help you all the way. You assume any expenses or risk.

    So, with the disclaimer out of the way, I see the browser makes a PUT call to

    https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DataFactory/factories/{factoryName}/integrationRuntimes/{integrationRuntimeName}/enableInteractiveQuery?api-version=2018-06-01
    
    

    With a body of

    {"autoTerminationMinutes":60}
    
    

    Whether the interactive authoring is currently enabled or not, is part of the ...integrationruntimes/{IntegrationRuntimeName}/getStatus?api-version=2018-06-01

    under $.properties.typeProperties.interactiveQuery.status

    0 comments No comments

  2. PRADEEPCHEEKATLA-MSFT 75,131 Reputation points Microsoft Employee
    2023-07-19T06:20:34.29+00:00

    @Dinesh Prajapati - Thanks for the question and using MS Q&A platform.

    You can enable Interactive query using REST API.

    Integration Runtimes - Enable Interactive Query - Enable interactive query in integration runtime.

    POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/integrationRuntimes/{integrationRuntimeName}/enableInteractiveQuery?api-version=2021-06-01-preview
    

    Here the walk through on how to enable Interactive query using REST API.

    ENableAutoResolveIR

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments