cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

AnalysisException: [RequestId=... ErrorClass=INVALID_PARAMETER_VALUE] Missing cloud file system scheme

HasiCorp
New Contributor II

Hi community,

i get an analysis exception when executing following code in a notebook using a personal compute cluster. Seems to be an issue with permission but I am logged in with my admin account. Any help would be appreciated.

USE CATALOG catalog;
USE SCHEMA db;
 
DROP TABLE IF EXISTS CUSTOM_LOGGING;
CREATE TABLE IF NOT EXISTS CUSTOM_LOGGING
USING TEXT
OPTIONS(path '/FileStore/logs/*',header=true)

When I comment out both USE statements and Detach&re-attach the cluster and run it, I get no error.

1 ACCEPTED SOLUTION

Accepted Solutions

Leonardo
New Contributor III

I was having the same issue because I was trying to set the location with the absolute path, just like you did.

I solved it by creating an external location, then copying the URL and putting it into the location of the path options.

View solution in original post

3 REPLIES 3

Anonymous
Not applicable

@Hasan Cetinkaya​ :

It seems like there may be a permission issue with the USE CATALOG and USE SCHEMA statements in your code. This suggests that the user account that you are using to run the code may not have sufficient privileges to access the specified catalog and schema.

To resolve this issue, you may need to check the permissions of your user account and ensure that it has been granted the necessary privileges to access the catalog and schema.

If you could try running the code without the USE CATALOG and USE SCHEMA statements, as you mentioned in your question. In this case, the table will be created in the default schema for your user account, which should not require any additional permissions.

If you still encounter issues, you may want to contact the Databricks support team for further assistance.

Anonymous
Not applicable

Hi @Hasan Cetinkaya​ 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance! 

Leonardo
New Contributor III

I was having the same issue because I was trying to set the location with the absolute path, just like you did.

I solved it by creating an external location, then copying the URL and putting it into the location of the path options.

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!