AuthenticationFailed when create a Synapse workspace

Question

AuthenticationFailed when create a Synapse workspace

Zhen Chen 6 Microsoft Employee

Follow the Synase doc(Creating a Synapse workspace : https://learn.microsoft.com/en-us/azure/synapse-analytics/get-started-create-workspace), when I finished all the steps, I want to get this through this URL，

but failed, the log is : {"error":{"code":"AuthenticationFailed","message":"Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.\nRequestId:eff9c66b-901f-0053-260a-a6e6dc000000\nTime:2021-09-10T06:10:07.1162497Z"}}

My URL : https://czcontosolake.dfs.core.windows.net/users/NYCTripSmall.parquet

Can anyone help me ?

Thomas Boersma 806 Reputation points

2021-09-13T09:05:28.207+00:00

Hi anonymous user-2100,

Thanks for using Microsoft Q&A. Can you provide some more information how you are requesting the .parquet file. Do you request it by a SQL statement?
Adam D. Benson 0 Reputation points

2024-02-02T16:45:10.2866667+00:00

This has become a blocker. I cannot find the URL that would work for my project. I have used each of the URLs: Dedicated SQL endpoint, Serverless SQL endpoint, and Development endpoint listed on the workspace page. Where do I go to find the equivalent to the root of "https://contosolake.dfs.core.windows.net"?

1 answer

Your answer

Thomas Boersma 806 Reputation points

2021-09-13T09:05:28.207+00:00

Hi anonymous user-2100,

Thanks for using Microsoft Q&A. Can you provide some more information how you are requesting the .parquet file. Do you request it by a SQL statement?
Adam D. Benson 0 Reputation points

2024-02-02T16:45:10.2866667+00:00

This has become a blocker. I cannot find the URL that would work for my project. I have used each of the URLs: Dedicated SQL endpoint, Serverless SQL endpoint, and Development endpoint listed on the workspace page. Where do I go to find the equivalent to the root of "https://contosolake.dfs.core.windows.net"?

Answer 1

Hello anonymous user-2100, ,
Thanks for the ask and using Microsoft Q&A platform .

I think you are refering to the below text from the doc

Once the parquet file is uploaded it is available through two equivalent URIs:
https://contosolake.dfs.core.windows.net/users/NYCTripSmall.parquet
abfss://*****@contosolake.dfs.core.windows.net/NYCTripSmall.parquet
In the examples that follow in this tutorial, make sure to replace contosolake in the UI with the name of the primary storage account that you selected for your workspace.*

This lines does not mean that you will able to access the paraquet file through the url , what it means is in the next tutorial we will be use the files which are uploaded here

Please do let me know how it goes .
Thanks
Himanshu

-------------------------------------------------------------------------------------------------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator

2021-09-29T16:55:32.813+00:00

Hello anonymous user-2100, ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

Share via

AuthenticationFailed when create a Synapse workspace

1 answer

Your answer