Use Keyvault secret in copy activity via notebook mssparkutils.notebook.exit()

[Anonymous]

I'm using a notebook activity to get the required secret from my azure keyvault. 
Using the 'mssparkutils.notebook.exit("MySecret")' I was hoping to be able to extract the value in my copy activity. 

In the additional headers I've created: Authorization with value (dynamic input) 

@activity('GetKeyvaultSecret').output.result.exitValue. 

I can see it's being passed as [redacted] which is the same as in the notebook activity? But in my notebook I can use this returned secret to authenticate. 

Am I doing something wrong? Or is this just not possible? 

because with this notebook I'm able to call the API; 

[evrise]

Pipeline copy activity will not work with private keyuvalt. You need Managed Private endpoint to access it. So now (Keyvault connection is in private prieview only) you have to use notebook. So the question is still same. How to get secret from notebook to pipeline if its REDACTED on notebook side?
Thanks 

[spencer_sa]

"How to get secret from notebook to pipeline if its REDACTED on notebook side?"
As it stands not without breaking the security of the Key Vault python functions.  And if you did discover a way you probably ought to raise a support ticket about it because the point of putting a secret in a Vault is that it isn't usable in its clear text form.

[evrise]

So? How to get a secret from KeyVault using Data Pipeline? 
Accepted solution is not a solution. Nobody has public KeyVault accessible from any network via Web request. 
Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

Thanks for using Fabric Community.
As I understand you are trying to access Azure KeyVault secret from Fabric Pipelines

Can you please refer below docs -
Solved: Re: Accessing Azure KeyVault secret for Fabric Cop... - Microsoft Fabric Community
Get Azure Key Vault secrets in Fabric pipeline – Simplyfies

FYI: If you are checking for Azure Key Vault feature in Data Factory Activities, then it will available soon.

Docs to refer - What's new and planned for Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Hope this is helpful. Please do let me know incase of further queries.