CODEWITHSUNDEEP
terraformazure-virtual-networkinfrastructure-as-codeazure-data-factory
Aniket Karajgikar
Aniket Karajgikar

Reputation: 305

How to enable interactive authoring while deploying Data Factory Azure IR on managed vNet through Terraform?

I am using below Terraform code to deploy Data factory Azure IR in managed virtual network:

resource "azurerm_data_factory_integration_runtime_azure" "ManagedIR" {
  name            = "ManagedIR"
  data_factory_id = azurerm_data_factory.datafactory.id
  location        = var.location
  resource_group_name = "****"
  virtual_network_enabled = true
  time_to_live_min = 60
}

But after successfully deploying it, I see 'Interactive authoring' to be disabled as below: disabled

Is there any setting in Terraform through which I can enable 'Interactive authoring' as well?

Upvotes: 7

Views: 5505

Answers (3)

CHEEKATLAPRADEEP
CHEEKATLAPRADEEP

Reputation: 12788

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.

enter image description here

Upvotes: 0

jravenger4
jravenger4

Reputation: 163

Here is what worked for me, you can refer to this link to use Azure/azapi.

Upvotes: 0

guylau
guylau

Reputation: 11

I can't find any approach to enable Interactive Authoring using Bicep/Terraform. I ended up using an undocumented REST API for ADF (but documented for Synapse):

$irResourceId = "subscriptions/<your-subscription-id>/resourcegroups/<your- 
rg-name>/providers/Microsoft.DataFactory/factories/<your-adf-name>/integrationruntimes/<your-ir-name>"
$command = "enableInteractiveQuery?api-version=2018-06-01"
$apiUrl = "https://management.azure.com/$irResourceId/$command"
az rest --url $apiUrl --method 'POST' --body '{ "autoTerminationMinutes": 10 }'

FYI: Synapse Rest API: https://learn.microsoft.com/en-us/rest/api/synapse/integration-runtimes/enable-interactive-query

Upvotes: 1

Related Questions