- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, yes that's the one. Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @MarkBurgess ,
Thanks for using Fabric Community.
Are you talking about SQL connection string (inorder to connct with lakehouse uisng SSMS)?
If not can you please explain your query more so that I can help you.
Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-02-2024 05:23 AM | |||
10-09-2024 02:35 AM | |||
10-10-2024 07:52 AM | |||
Anonymous
| 05-05-2023 09:43 AM | ||
09-13-2024 12:01 PM |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |