How to resolve Location Overlap

ep208
New Contributor

‎05-14-2025 11:43 PM - edited ‎05-14-2025 11:46 PM

Hi,

I am trying to ingest abfss://datalake@datalakename.dfs.core.windows.net/Delta/Project1/sales_table but when writting the table schema on the yamls, I uncorrectly wrote this table in other unit catalog table:

---
kind: SinkDeltaTable
metadata:
  name: delta-Project1-sales_table
spec:
  dataLakeConnection: dlc-datalake
  database: dbrdelta
  table: post_sales
  tablePath: Delta/Project1/sales_table
 
Once I realized of my mistake, i corrected it: 
---
kind: SinkDeltaTable
metadata:
  name: delta-Project1-sales_table
spec:
  dataLakeConnection: dlc-datalake
  database: dbrdelta
  table: sales_table
  tablePath: Delta/Project1/sales_table
 
 
As I have run the code with the typo, after I have refined the yaml, I tried again to create the sales_table but I got this message:

AnalysisException: [RequestId=79ba396e-1572-4ae7-9ae5-004467cb5b10 ErrorClass=INVALID_PARAMETER_VALUE.LOCATION_OVERLAP] Input path url 'abfss://datalake@datalakename.dfs.core.windows.net/Delta/Project1/sales_table' overlaps with other external tables or volumes within 'CreateTable' call. Conflicting tables/volumes: datalakename.dbrdelta.post_sales.

I have tried to remove the table in DL and in Unit Catalog, but still the Databricks job failed. Furthermore, I have checked out the schema table and it seems correct.

Do you have any idea how to amend this error?

0 Kudos