Azure-Samples / modern-data-warehouse-dataops

DataOps for the Modern Data Warehouse on Microsoft Azure. https://aka.ms/mdw-dataops.
MIT License
570 stars 451 forks source link

Azure DataShare automation sample #573

Closed QuickNS closed 1 year ago

QuickNS commented 1 year ago

Problem Statement

There is a lack of samples and examples on how to use Azure Data Share in an automated way. In a scenario where a company wants to share data with another company, the Data Share service makes it very easy accomplish that goal but the actual process of setting up the data share involves a lot of steps:

Sending an invitation to a service principal allows to fully automate the scenario on both the source and destination as we can have an Azure Function ready to accept invitations sent to a specific service principal or its managed identity.

While this is discoverable by exploring the Invitations API, it is not trivial to implement.

Proposed Solution

A working sample of a fully automated Azure Data share process under /single_tech_samples/datashare that fully implements the steps outlined above and includes step-by-step documentation on how to run the code and adapt it to other scenarios.

Additional Context

I already have a full working sample written in Python that includes simple scripts for sending/receiving invitations and an Azure Function that automates the invitation acceptance and mapping of the incoming data in a destination Data Share account. I will submit it as a PR if this is accepted.

Next Steps