Oct 07 2021 06:49 AM - edited Oct 07 2021 07:13 AM
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.