Getting error while creating external delta table in Databricks

Siddalinga
New Contributor

‎01-21-2025 06:14 AM

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'
Labels:
0 Kudos