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