cancel
Showing results for 
Search instead for 
Did you mean: 
Community Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot create delta location with mount path

NhanNguyen
Contributor II

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?
1 ACCEPTED SOLUTION

Accepted Solutions

AmanSehgal
Honored Contributor III

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.

View solution in original post

2 REPLIES 2

AmanSehgal
Honored Contributor III

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.

NhanNguyen
Contributor II

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