Cannot create delta location with mount path

[jensen22]

Hi all,

I'm trying to create a Table but cannot use a predifined mount path like '/mnt/silver/' but if i use a full path of azure blob container it will create susscessfully like this:
`

CREATE TABLE IF NOT EXISTS nhan_databricks.f1_processed.circuits (

cardReferenceID string,

modifiedDate TIMESTAMP,

createdDate TIMESTAMP,

clientCode string,

processorCode string

)

USING DELTA

LOCATION "abfss://test@formula1dlnt.dfs.core.windows.net/table_name"

TBLPROPERTIES (

delta.enableChangeDataFeed = true,

spark.databricks.delta.schema.autoMerge.enabled = true

);`

So we cannot use the mount path when create a delta table with location?

[AmanSehgal · Accepted solution]

As per my understanding, this is because you're trying to create a table in unity catalog and not in hive_metastore.

If you create a table in hive_metastore, then dbfs mount location will work. However, for any other catalog you need to sepcify the path as per cloud file system scheme (Azure: abfss:// , AWS: s3://)

Hope this helps.

[jensen22]

Oh thanks for you answer, actually I'm using Unity Catalog