Forum Discussion

govindarajan_d's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

Generic user account for warehouse SQL Endpoint

Usually, we create a generic SQL account for reports so that it is not tied to any personal account. I read from the documentation that SQL authentication is not supported in warehouse. What would be...
admin
data warehouse
security
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi govindarajan_d ,

Thanks for using Fabric Community. 
Can you please explain your ask more clearly? I would like to know few more details so that I can guide you better.

govindarajan_d's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

Hi Anonymous,

 

For example, I can create a new SQL user 'dashboard_data_user' and use it as a generic account for all my reports which will use the SQL user authentication while loading data.

 

How do I do it in Fabric Warehouse, when it doesn't have SQL authentication. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi govindarajan_d ,

    Thanks for using Fabric Community.
    At this time, we are reaching out to the internal team to get some help on this .
    We will update you once we hear back from them.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi govindarajan_d ,

      The best course of action is to open a support ticket and have our support team take a closer look at it.

       

      Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link 

       

      After creating a Support ticket please provide the ticket number as it would help us to track for more information.

       

      Hope this helps. Please let us know if you have any other queries.