No parent external location found for <S3-location> | External Table in UnityCatalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-25-2022 05:24 AM
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.
- Labels:
-
External Table
-
Location
-
Unity Catalog