No parent external location found for <S3-location> | External Table in UnityCatalog

Kanib
New Contributor III

Hi,

We are trying to adopt the Unity Catalog and are testing out creating an External table with some data from the samples catalog that comes along with creating a meta store. The command we are using is:

CREATE TABLE IF NOT EXISTS my_catalog.quickstart_schema.trips_external
LOCATION 's3://somebucket/path'
AS SELECT * from samples.nyctaxi.trips;

When I am running this command- I keep on getting an error

Error in SQL statement: NoParentExternalLocationForPathException: No parent external location found for path 's3://somebucket/path'

I was following the doc: https://docs.databricks.com/data-governance/unity-catalog/create-tables.html#create-a-table-from-the...

but I am not getting any information regarding this. Can someone please help me why is this error coming up?

When I try to read some data from this bucket - I am able to do so - meaning, I have the access to the bucket.