Creating table in Unity Catalog with file scheme dbfs is not supported.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2024 07:56 AM
Creating table in Unity Catalog with file scheme dbfs is not supported.
Instead, please create a federated data source connection using the CREATE CONNECTION command for the same table provider, then create a catalog based on the connection with a CREATE FOREIGN CATALOG command to reference the tables therein. I am getting this error . I am trying to create a table in Databricks workspace. I don't know How to create a connection for data which is residing in delta lake(s3) . Anyone can give me a code to create a connection and foreign catalog in databricks notebook .Here is my code.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2024 10:02 PM
@shiva123
As the error says, you cannot create a table with DBFS as location.
If you really need to create external table, please follow this guide: https://learn.microsoft.com/en-us/azure/databricks/tables/external

