Skip to main content

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:

Storing Data

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

Key Commands:

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:

Did this page help you?
Explore Databend Cloud for FREE
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today