topic Re: Cannot create delta location with mount path in Get Started Discussions

Cannot create delta location with mount path

NhanNguyen — Sun, 21 Apr 2024 06:32:20 GMT

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?

Re: Cannot create delta location with mount path

AmanSehgal — Sun, 21 Apr 2024 12:08:02 GMT

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.

Re: Cannot create delta location with mount path

NhanNguyen — Sun, 21 Apr 2024 12:55:18 GMT

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