04-11-2023 06:07 AM
I'm on Demo and Lab in Dataframes section. I've imported the dbc into my company cluster and has run "%run ./Includes/Classroom-Setup" successfully.
When i run the 1st sql command
%sql
CREATE TABLE IF NOT EXISTS events USING parquet OPTIONS (path "/mnt/training/ecommerce/events/events.parquet");
and i got this error
shaded.databricks.org.apache.hadoop.fs.azure.AzureException: hadoop_azure_shaded.com.microsoft.azure.storage.StorageException: Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
May i know how to resolve this issue?
04-15-2023 05:53 PM
@alex chooi :
The error message suggests that there is an authentication issue when accessing the Azure storage account where the data is stored.
To resolve this issue, you can try the following steps:
04-18-2023 08:01 AM
Hello!
I got exactly the same error and cannot continue with the course. Is it on our side to check these account keys and everything? Is not it something that should have been done for us (we are trying to access a storage that was defined in Common Notebooks to create mounts?) My colleagues easily went through the course, everything was ready out of the box. It is quite frustrating to get stuck at this point 😞
07-10-2023 05:43 AM
Same problem here, my theory is that is a problem with the notebook's course, because I can easily run other notebooks from other courses, for example "Data Engineering with Databricks V2" everything runs ok, but not the Spark Programming with Databricks that was last updated a year ago.
Please help.
09-07-2023 12:56 AM
I had the same issue and solved it like this:
In the includes folder, there is a reset notebook, run the first command, this unmounts all mounted databases.
Go back to the ASP 1.2 notebook and run the %run ./Includes/Classroom-Setup codeblock.
Then run the next codeblock:
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.