Hi @Swamy09 The error [NO_PARENT_EXTERNAL_LOCATION_FOR_PATH] indicates that there is no External Location configured for the storage path you are trying to use while creating the external table.
Before creating an external table, you must:
Create a Storage Credential
Create an External Location using that credential
Ensure the table path falls under the registered external location path
Example:

-- Step 1: Create external location
CREATE EXTERNAL LOCATION my_ext_loc
URL 'abfss://container@storageaccount.dfs.core.windows.net/path/'
WITH (STORAGE CREDENTIAL my_cred);

-- Step 2: Create external table
CREATE TABLE catalog.schema.my_table
USING DELTA
LOCATION 'abfss://container@storageaccount.dfs.core.windows.net/path/table_folder/';

Lokesh Rajpoot,