Table is being dropped when cluster terminates in comunity edition

Sas
New Contributor II

‎12-25-2023 09:39 PM

Hi Expert

I have created an external table in databricks community edition. Table is external table. But when i cluster is terminated, i am not able to query the table any more. What is the reason? What i need to do so that table is not dropped. Table creation script is as below

DeltaTable.createOrReplace(spark)\
    .tableName("delta_internal_demo")\
    .addColumn("emp_id",'INT')\
    .addColumn("emp_name",'STRING')\
    .addColumn("gender",'STRING')\
    .addColumn("Salary",'INT')\
    .addColumn('Dept','STRING')\
    .property("description",'table created for demo purpose')\
    .location("/FileStore/tables/delta/archival_demo")\
    .execute()
0 Kudos