Synapse with Cosmos data plane RBAC

David Baker 21 Reputation points
2021-11-03T22:12:40.747+00:00

Hi, I just started using Synapse for Cosmos DB. Is there a way to use OPENROWSET with RBAC for Cosmos? ie. when local auth on Cosmos is disabled.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,252 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,401 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,412 Reputation points Microsoft Employee
    2021-11-05T07:45:12.62+00:00

    Hi @David Baker ,

    Welcome to Microsoft Q&A forum and thanks for reaching out.

    Currently it is not possible to use OPENROWSET with RBAC for Cosmos. This is a known gap and the product team confirmed that they have noted this request and evaluate it.

    I would also recommend you to please share your feedback in IDEAS forum - https://feedback.azure.com/d365community
    All the feedback shared in this forum are actively monitored and reviewed by respective product owners.

    Also please do share your feedback link once it is posted so that we can share it with relevant owners.

    Hope this info helps.

    ----------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.