Unity Catalog - External Location

Question

All,

Going by the link : **https://docs.databricks.com/_extras/notebooks/source/unity-catalog-external-table-example-azure.html **in order to create External Tables.

-- Create a new external Unity Catalog table from an existing table

-- Replace <bucket_path> with the storage location where the table will be created

CREATE TABLE IF NOT EXISTS trips_external

LOCATION 'abfss://<bucket_path>'

AS SELECT * from samples.nyctaxi.trips;

When I already created the External Location, why am I still specifying LOCATION?

Answer 1

Hi Gopinath Rajee,

Thank you for posting query in Microsoft Q&A Platform.

In the link which you shared it mentioned how to create external location. But there was no example given for same. May be because of that they used path in create external table example. You can safely ignore that and try using external location there directly instead of path.

Hope this helps. Please let me know if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.