Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Use SQL Database in Data Pipelines

Hi all, So I've created a Fabric SQL database in my workpsace and using it to store some configuration for data pipelines I'm using lookups in Data Pipelines to fetch information from the Fabric SQ...
SQL database
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi Anonymous ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Service Principal (SPN) authentication is not supported for Fabric SQL Database connections used in Data Pipelines. The auto-created connection in “Manage Connections and Gateways” uses your personal token, and you cannot manually recreate it with other credentials. There is ongoing work to support Managed Identity and Service Principal based connections for Fabric items.

     

    Please monitor the roadmap for future releases:  https://roadmap.fabric.microsoft.com/?product=administration%2Cgovernanceandsecurity 

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thank you!!

v-sathmakuri's avatar
v-sathmakuri
Community Support
1 year ago

Hi Anonymous ,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Service Principal (SPN) authentication is not supported for Fabric SQL Database connections used in Data Pipelines. The auto-created connection in “Manage Connections and Gateways” uses your personal token, and you cannot manually recreate it with other credentials. There is ongoing work to support Managed Identity and Service Principal based connections for Fabric items.

 

Please monitor the roadmap for future releases:  https://roadmap.fabric.microsoft.com/?product=administration%2Cgovernanceandsecurity 

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thank you!!