Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
MarkBurgess
Frequent Visitor

User friendly SQL endpoints

Hi, I seem to recall someone in a presentation saying that it was possible to get a more user friendly SQL endpoint for your Fabric resources if you didn't use spaces in your workspace name but I'm yet to acheive this. By user friendly I mean something that resembles your workspace name rather than a string of random characters. Does anyone know if this is possible?

 

Many thanks

1 ACCEPTED SOLUTION
AndyDDC
Solution Sage
Solution Sage

Hi @MarkBurgess the only user-friendly naming convention is for accessing the workspace storage using the OneLake URI, not the sql endpoint (at this time I believe).  So if you create a workspace with no spaces, then you can acess your workspace storage using a tool like Azure Storage Explorer with the name of the workspace:

 

But if your workspace has spaces in, then you need to use the GUID of the workspace (easily found in the URL of the worksapce when you browse it)

 

Then you'd access it using the GUID instead of the name:

 

View solution in original post

5 REPLIES 5
AndyDDC
Solution Sage
Solution Sage

Hi @MarkBurgess the only user-friendly naming convention is for accessing the workspace storage using the OneLake URI, not the sql endpoint (at this time I believe).  So if you create a workspace with no spaces, then you can acess your workspace storage using a tool like Azure Storage Explorer with the name of the workspace:

 

But if your workspace has spaces in, then you need to use the GUID of the workspace (easily found in the URL of the worksapce when you browse it)

 

Then you'd access it using the GUID instead of the name:

 

Okay, thanks @AndyDDC that makes sense.

Hi @MarkBurgess ,

Glad to know that your query got resolved. Please continue using Fabric Community for your further queries.

Below link helps you to get more idea on One Lake URI
How do I connect to OneLake? - Microsoft Fabric | Microsoft Learn

MarkBurgess
Frequent Visitor

Hi, yes that's the one. Thank you

v-gchenna-msft
Community Support
Community Support

Hi @MarkBurgess ,

Thanks for using Fabric Community.

Are you talking about SQL connection string (inorder to connct with lakehouse uisng SSMS)?

vgchennamsft_0-1701941982318.png



If not can you please explain your query more so that I can help you.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Fabric Hack Slide Banner

Hack Together: The Microsoft Fabric AI Global Hack

Learn from experts, get hands-on experience, and win awesome prizes.