Credential in synapse workspcae

New Contributor

Hi,

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