DROP ENTITY

Syntax

DROP ENTITY fully_qualified_entity_name;

Description

This command deletes an entity in a Store.

Arguments

fully_qualified_entity_name

The full name of the entity to describe.

Examples

Drop a Snowflake database

demodb.public/sfstore# LIST ENTITIES;
       Entity name       
-------------------------
  MY_SNOWFLAKE_DB        
  SNOWFLAKE              
  SNOWFLAKE_SAMPLE_DATA  
demodb.public/sfstore# DROP ENTITY "MY_SNOWFLAKE_DB";
demodb.public/sfstore# LIST ENTITIES;
       Entity name       
-------------------------
  SNOWFLAKE              
  SNOWFLAKE_SAMPLE_DATA  

Drop a Snowflake schema

demodb.public/sfstore# LIST ENTITIES IN "DELTA_STREAMING";
     Entity name      
----------------------
  INFORMATION_SCHEMA  
  MY_SCHEMA           
  PUBLIC              
demodb.public/sfstore# DROP ENTITY "DELTA_STREAMING"."MY_SCHEMA";
demodb.public/sfstore# LIST ENTITIES IN "DELTA_STREAMING";
     Entity name      
----------------------
  INFORMATION_SCHEMA  
  PUBLIC              

Drop a Snowflake table

demodb.public/sfstore# LIST ENTITIES IN "DELTA_STREAMING"."PUBLIC";
    Entity name    
-------------------
  STREAM_DATA_TBL  
  sf_pv_table      
demodb.public/sfstore# DROP ENTITY "DELTA_STREAMING"."PUBLIC".sf_pv_table;
demodb.public/sfstore# LIST ENTITIES IN "DELTA_STREAMING"."PUBLIC";
    Entity name    
-------------------
  STREAM_DATA_TBL  

Drop a Databricks catalog

demodb.public/databricks_store# LIST ENTITIES;
        Entity name
---------------------------
  catalog1
  main
  system
demodb.public/databricks_store# DROP ENTITY catalog1;
demodb.public/databricks_store# LIST ENTITIES;
       Entity name       
-------------------------
  main
  system

Drop a Databricks schema

demodb.public/databricks_store# LIST ENTITIES IN catalog1;
     Entity name
----------------------
  default
  information_schema
  schema1           
demodb.public/databricks_store# DROP ENTITY catalog1.schema1;
demodb.public/databricks_store# LIST ENTITIES IN catalog1;
     Entity name
----------------------
  default
  information_schema        

Drop a Databricks table

demodb.public/databricks_store# LIST ENTITIES IN catalog1.schema1;
  Entity name
---------------
  pageviews
  pv_agg
demodb.public/databricks_store# DROP ENTITY catalog1.schema1.pageviews;
demodb.public/databricks_store# LIST ENTITIES IN catalog1.schema1;
  Entity name
---------------
  pv_agg