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 ACCEPTED SOLUTION

Accepted Solutions

Kaniz_Fatma
Community Manager
Community Manager

Hi @Scott_in_Zurich , Thank you for posting your concern on Community!

To expedite your request, please list your concerns on our ticketing portal. Our support staff would be able to act faster on the resolution (our standard resolution time is 24-48 hours).

View solution in original post

2 REPLIES 2

Kaniz_Fatma
Community Manager
Community Manager

Hi @Scott_in_Zurich , Thank you for posting your concern on Community!

To expedite your request, please list your concerns on our ticketing portal. Our support staff would be able to act faster on the resolution (our standard resolution time is 24-48 hours).

Scott_in_Zurich
New Contributor III

Done, thanks!

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!