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()