DeltaStream
Search
K

CREATE ENTITY

Syntax

CREATE ENTITY fully_qualified_entity_name;

Description

This command creates a new entity supported by a Store. These entities can then be used to host Relations created through DDL or Query.
The entities created by this command can be listed using the LIST ENTITIES command.

Arguments

fully_qualified_entity_name

The full name of the entity to create.

Examples

Create a Snowflake database

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

Create a Snowflake schema in a database

In this example we create a new schema within the existing DELTA_STREAMING Snowflake database:
demodb.public/sfstore# CREATE ENTITY "DELTA_STREAMING"."MY_STREAMING_SCHEMA";
demodb.public/sfstore# LIST ENTITIES IN "DELTA_STREAMING";
Entity name
-----------------------
INFORMATION_SCHEMA
MY_STREAMING_SCHEMA
PUBLIC

Create a Databricks catalog

demodb.public/databricks_store# CREATE ENTITY cat1;
demodb.public/databricks_store# LIST ENTITIES;
Entity name
---------------------------
cat1
main
system

Create a Databricks schema in a catalog

In this example we create a new schema within the existing DELTA_STREAMING Snowflake database:
demodb.public/databricks_store# CREATE ENTITY cat1.schema1;
demodb.public/databricks_store# LIST ENTITIES IN cat1;
Entity name
----------------------
default
information_schema
schema1