cancel
Showing results for 
Search instead for 
Did you mean: 
Databricks Free Trial Help
Engage in discussions about the Databricks Free Trial within the Databricks Community. Share insights, tips, and best practices for getting started, troubleshooting issues, and maximizing the value of your trial experience to explore Databricks' capabilities effectively.
cancel
Showing results for 
Search instead for 
Did you mean: 

Getting error while creating external delta table in Databricks

Siddalinga
New Contributor

I am getting below error while creating external delta table in Databricks, even there is a external location created.

[NO_PARENT_EXTERNAL_LOCATION_FOR_PATH] No parent external location was found for path 'abfss://destination@datalakeprojectsid.dfs.core.windows.net/salesdb/Person'. Please create an external location on one of the parent paths and then retry the query or command again.

%sql
CREATE TABLE Sales.Person
(
  id INT,
  name STRING,
  marks INT
)
USING DELTA
LOCATION 'abfss://destination@datalakeprojectsid.dfs.core.windows.net/salesdb/Person'
1 REPLY 1

TakuyaOmi
Valued Contributor II

@Siddalinga 

If the path specified during table creation is outside the scope of the external location, you may encounter the [NO_PARENT_EXTERNAL_LOCATION_FOR_PATH] error.
Is the external location correctly defined to scope the directory, such as abfss://destination@datalakeprojectsid.dfs.core.windows.net/salesdb, including the salesdb subdirectory?

Please double-check to ensure the external location is properly configured.

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