Unity Catalog - External Location

Gopinath Rajee 651 Reputation points
2023-06-01T04:23:49.5066667+00:00

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?

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,068 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
    2023-06-01T13:00:47.4466667+00:00

    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.