Getting error while creating external delta table in Databricks

[Siddalinga]

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'

[Takuya-Omi]

@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.

[saisaran_g]

Hello @Siddalinga,

Is the issue fixed ? If not please check below options : 

1. external location is created in databricks with proper service account or service principle ? 

2. Or any storage location is attached with proper service account. ?

Above 2 methods will establish the connection between databricks VM with external stroage connectivity. 

Happy learning.
Saran