The associated location ('dbfs:/user/hive/warehouse/databricks_documentation') is not empty and also not a Delta table.

[rileynjohnson]

Hoping for some help on this one, too!

%sql
DROP TABLE IF EXISTS databricks_documentation;
--Note that we need to enable Change Data Feed on the table to create the index
CREATE TABLE IF NOT EXISTS databricks_documentation (
  id BIGINT GENERATED BY DEFAULT AS IDENTITY,
  url STRING,
  content STRING,
  embedding ARRAY <FLOAT>
) TBLPROPERTIES (delta.enableChangeDataFeed = true); 

DeltaAnalysisException: [DELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATION] Cannot create table ('spark_catalog.default.databricks_documentation'). The associated location ('dbfs:/user/hive/warehouse/databricks_documentation') is not empty and also not a Delta table.

[QuentinAmbard]

hey, I think you just forgot to run the init cell. It should setup your catalog by default to use the main catalog.
Just make sure you run the initial %run ../_resource/01-init cell and it'll fix the issue!
feel free to re-open if it's not the case