Data Factory v1 - edit linked service with dependancies.

bhb252 1 Reputation point
2021-01-24T13:49:26.087+00:00

We've moved all of our data factory v1 jobs to v2 except for a few that we're unable to at this point.

I need to edit the values in a linked service. I understand that that is no longer supported in the portal and must be done via powershell or rest api. When I tried to delete the linked service I received the error- cannot delete due to dependencies. The issue now is that I have quite a few datasets that rely on the linked service. I need to take backups and then restore the datasets, even then I pipelines that depend on those too further in the ETL process.

It appears that there is no way to edit-in-place the linked service. Is there a way that would allow me to edit without having to delete linked service, datasets, and possibly even more?

Thanks

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

1 answer

Sort by: Most helpful
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2021-01-27T06:01:23.527+00:00

    Hi @bhb252 ,

    Thanks for your patience. I looked at the documentation of New-AzDataFactoryLinkedService and below is a note that explains it can be used to replace existing linked services as well without deleting them.

    The New-AzDataFactoryLinkedService cmdlet links a data store or a cloud service to Azure Data Factory. If you specify a name for a linked service that already exists, this cmdlet prompts you for confirmation before it replaces the linked service. If you specify the Force parameter, the cmdlet replaces the existing linked service without confirmation

    Please let us know for further queries and we will be glad to assist.

    --

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.