Creating un-managed table

Question

Creating un-managed table: June_date_eom
dbfs:/mnt/devamcluecontainer/AFTERMARKET_CLUE/PipelineCleanedData/ June_date_eom
Out[365]: {'status': 1,
'MESSAGE': "ERROR: The location of the existing table default.June_date_eom is dbfs:/mnt/development/AFTERMARKET_CLUE/PipelineCleanedData/June_date_eom. It doesn't match the specified location dbfs:/mnt/devamcluecontainer/AFTERMARKET_CLUE/PipelineCleanedData/June_date_eom."}

Answer 1

Hello @M Ravichandran, Saravanan ,

Thanks for the question and using MS Q&A platform.

From the error message it clearly says - The location of the existing table doesn't match with the specified location.

• Existing table location: dbfs:/mnt/development/AFTERMARKET_CLUE/PipelineCleanedData/June_date_eom
• Specified table location: dbfs:/mnt/devamcluecontainer/AFTERMARKET_CLUE/PipelineCleanedData/June_date_eom

To resolve this issue, make sure to the location of the existing and specified table should be same.

For tables defined in the metastore, you can optionally specify the LOCATION as a path. Tables created with a specified LOCATION are considered unmanaged by the metastore.

For more details, refer to Azure Databricks - Control data location.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators