cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results for 
Search instead for 
Did you mean: 

Tutorial "Query Data from a Notebook": access errors

Scott_in_Zurich
New Contributor III

I am trying to work through Tutorial: Query data from a Notebook.

Access errors are defeating my attempts. Steps to reproduce:

  1. sign up for free trial through Databricks website. The path skipped the subscription-selection step and defaulted the trial to Premium.
  2. create workspace using AWS Quick Start
  3. create a cluster. Runtime 13.3
  4. create a notebook
  5. step 3 option 1, Create Spark table from the CSV data 
    1. expected behavior: table created successfully
    2. actual behavior: error UnityCatalogServiceException: [RequestId=d548e435-f8ec-49e4-b134-520d96b27cd6 ErrorClass=INVALID_PARAMETER_VALUE] GenerateTemporaryPathCredential uri databricks-datasets/Rdatasets/data-001/csv/ggplot2/diamonds.csv is not a valid URI. Error message: INVALID_PARAMETER_VALUE: Missing cloud file system scheme.
  6. Step 3 option 2, Write the CSV data to Delta Lake format and create a Delta table
    1. expected behavior: both steps complete successfully
    2. actual behavior: step 1 completes successfully. Step 2 ("Create a Delta table at the stored location") fails with error UnityCatalogServiceException: [RequestId=89804dc3-8c28-43f0-865b-aa80e0a1bd0d ErrorClass=INVALID_PARAMETER_VALUE] GenerateTemporaryPathCredential uri /mnt/delta/diamonds is not a valid URI. Error message: INVALID_PARAMETER_VALUE: Missing cloud file system scheme.

Reading past forum messages suggests that the issue results from lack of storage credentials and/or external locations (https://docs.databricks.com/en/data-governance/unity-catalog/manage-external-locations-and-credentia...). This seems like an issue that the stack created through the AWS Quick Start setup would have dealt with. Is there an incompatibility between the tutorial instructions and use of Unity Catalog?

Can anyone suggest how to resolve this issue with the least effort?

1 REPLY 1

Scott_in_Zurich
New Contributor III

Done, thanks!

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group