Forum Discussion

Barre's avatar
Barre
Helper I
2 years ago

Fabric Lakehouse - Multiple SQL Endpoint Connection String

Hi,

 

Why do I have 2 different SQL Endpoint connection strings for different lakehouses located in the same workspace?

E.g lakehouse abc123 has the following SQL Endpoint connection string

   - xxx-xxx.datawarehouse.fabric.microsoft.com

 

Lakehouse def456 has the following SQL Endpoint connection string

   - xxx-xxx.datawarehouse.pbidedicated.windows.net

 

To retrieve the connection string, I click on the three dots (...) on the lakehouse and select View details.

 

Need Help

2 Replies

    • Barre's avatar
      Barre
      Helper I
      2 years ago

      Hi Arul , thank you for the response.

       

      Yes, I´m aware that the SQL Endpoint connection string is the exact same for all lakehouses when stored in the same workspace. But my question is, why do some lakehouses, that are located in the same workspace in Fabric, have different naming in the SQL Endpoint connection string after datawarehouse.?

       

      I have these 2 lakehouses in my workspace.

      Lakehouse 1 has this SQL Endpoint - xxx-xxx.datawarehouse.fabric.microsoft.com

      Lakehouse 2 has this SQL Endpoint - xxx-xxx.datawarehouse.pbidedicated.windows.net

       

      Why do lakehouse 1 have FABRIC and lakehouse 2 have PBIDEDICATED?