Retrieving SQL credentials in devOps pipeline

[pascalm23]

Hi,

I'm using the ADF version of that script which works great. I'm trying to do the same for Synapse, but noticed that credentials are required here:
-SqlAdministratorLoginCredential $cred

I'm using a pipeline devOps (powershell task in a yaml file) and was wondering if someone could give an example on how to initialize $cred variable.

Thanks,
Pascal.

[pascalm23]

script being: Publish-SynapseFromJson.ps1

[NowinskiK]

Check this out:
https://stackoverflow.com/questions/73648383/azure-pipelines-setting-and-passing-the-password-in-powershell-script