Share via

Azure Data Share specific column selection during Data Share creation from Provider

Balan Murugan 41 Reputation points
2024-05-01T11:36:31.6233333+00:00

As part of one of my migration project requirements, my source team has agreed to share their data using Azure Data Share. But, they are not willing to share the PII data over Azure Data Share.

Does Azure Data share supports selection of specific columns (Non-PII columns) while creating data share from provider?

If yes, can you help to have required MS documentation for the steps.

If it does not supports, what are the other options, I can think of for this solution.

Appreciate your support !

Azure Data Share
Azure Data Share

An Azure service that is used to share data from multiple sources with other organizations.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    2024-05-01T17:56:32.1333333+00:00

    Hello Balan Murugan,

    Unfortunately, Azure Data Share does not directly support column selection (projection) during data sharing

    As an alternatives:

    You can ask the source team to create a view that includes only non-PII columns and share the view via Azure data share.

    If Azure Data Share does not meet your requirements, you might explore other data-sharing options such as ADF, Synapse and Azure databricks.

    I hope this answers your questions.

    1 person found this answer helpful.

Your answer

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