Data Lifecycle in Databend

Databend supports familiar Data Definition Language (DDL) and Data Manipulation Language (DML) commands, making it easy for you to manage your database. Whether you're organizing, storing, querying, modifying, or deleting data, Databend follows the same industry standards you're accustomed to.

Databend Objects

Databend supports the following objects to create and modify them:

• Database
• Table
• External Table
• Stream
• View
• Index
• Stage
• File Format
• Connection
• User Defined Function (UDF)
• External Function
• User
• Role
• Grants
• Warehouse
• Pipe
• Task

Organizing Data

Arrange your data in databases and tables.

Key Commands:

• CREATE DATABASE: To create a new database.
• ALTER DATABASE: To modify an existing database.
• CREATE TABLE: To create a new table.
• ALTER TABLE: To modify an existing table.

Storing Data

Directly add data to your tables. Databend also allows importing data from external files into its tables.

Key Commands:

• INSERT: To add data to a table.
• COPY INTO <table>: To bring in data from an external file.

Querying Data

After your data is in the tables, use SELECT to look at and analyze it.

Key Command:

• SELECT: To get data from a table.

Working with Data

Once your data is in Databend, you can update, replace, merge, or delete it as needed.

Key Commands:

• UPDATE: To change data in a table.
• REPLACE: To replace existing data.
• MERGE: To seamlessly insert, update, and delete by comparing data between main and source tables or subqueries.
• DELETE: To remove data from a table.

Removing Data

Databend allows you to delete specific data or entire tables and databases.

Key Commands:

• TRUNCATE TABLE: To clear a table without deleting its structure.
• DROP TABLE: To remove a table.
• DROP DATABASE: To delete a database.