Forum Discussion
How do you delete a data connector
sijmalik You can't delete a data connector, you can just turn it off by disabling whatever mechanism is being used to import the data.
In the case of the Azure SQL you would delete the diagnostic setting that is sending the data into your Log Analytics workspace.
GaryBushey After deleting the diagnositic setting for Azure Activity, it still shows as connected even though logs have stopped. Is there any way to get it to recognise it is disconnected as it cannot be reconnected otherwise
John_Maton I think, and if anyone knows for sure please correct me, it is showing as connected because there is data in the tables that is has populated. Once that data gets removed (and you can set table level retention to remove it after 30 days) it will no longer show as connected.
- AzureActivity may also data from other resources in there if people have turned on diagnostics settings elsewhere, that table can be a bit of a disaster depending on whats connected but you can summarize by resource group at least
Maybe have a look for entries since you disabled the Azure SQL logging and see if anything else is pushing data in
AzureActivity
| where TimeGenerated > ago(2d)
| summarize count()by ResourceGroup