Data Lifecycle in TiDB Cloud Lake
TiDB Cloud Lake 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, TiDB Cloud Lake follows the same industry standards you're accustomed to.
TiDB Cloud Lake Objects
TiDB Cloud Lake 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
- Task
- Snapshot Tag
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. TiDB Cloud Lake 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 TiDB Cloud Lake, 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
TiDB Cloud Lake 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.