DeltaStream
Search
K

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