Shared Access signature Server Level Credential Synapse Serverless pool
The following script creates a server-level credential that can be used by the OPENROWSET function to access any file on Azure storage using SAS token.
CREATE CREDENTIAL https://mystorageaccountname.dfs.core...
WITH IDENTITY='SHARED ACCESS SIGNATURE'
, SECRET = 'sv=2018-03-28&ss=bfqt&srt=sco&sp=rwdlacup&se=2019-04-18T20:42:12Z&st=2019-04-18T12:42:12Z&spr=https&sig=lQHczNvrk1BrIPBNJ3VYEIq78%3D'