Credential in synapse workspcae

Copper Contributor


I have linked a cosmos db to the synapse workspace. I am using server credentials to create a view/ in an openrowset().

Can I use a credential(ServicePrincipal/Managed Identity, not a server credential) in a manage -> security hub while creating a view in a serverless SQL pool? 

for e.g. in below syntax 


OPENROWSET( PROVIDER = 'CosmosDB', CONNECTION = '<SQL connection string for Azure Cosmos DB without account key>', OBJECT = '<Container name>', [ CREDENTIAL | SERVER_CREDENTIAL ] = '<credential name>' ) [ < with clause > ] AS alias


instead of using Server_credential can i use ServicePrincipal/Managed Identity  credential


I am getting error



Thank you.


0 Replies