Tencent Cloud

Recent Pages

Data View Management

Last updated: 2024-07-31 17:28:41

DLC provides data view query capabilities, allowing users to quickly and easily perform data queries and use through the management of data views.
Create View
1. log in to DLC console, select the service region, log in users must have the permission to create views.
2. Enter the Data Exploration page, you can create views using SQL statements. For details of the statement, see SQL Syntax.
3. Select the computing resource, click the Running button to complete view creation.
﻿
﻿
View Views
You can view the view using SQL statements through Data Exploration, see SQL Syntax for specific syntax. Meanwhile, DLC also offers a Visual Interface for managing views, with the following operations.
1. Log in to the DLC console, select the service region, log in users must have the permission to query views.
2. Enter the Data Management page, click on the Database Name where the view is located to enter the DMC page.
3. Click View to enter View Management.
﻿
﻿
4. Click the View Name you want to inspect to view its information. You can copy the SQL statement.
﻿
﻿
Delete View
You can view the view using SQL statements through Data Exploration, see SQL Syntax for specific syntax. Meanwhile, DLC also offers a Visual Interface for managing views, with the following operations.
1. Log in to DLC Console, select the service region, users must have view deletion permissions.
2. Enter the Data Management page, click on the Database Name where the view is located to enter the DMC page.
3. Click View to enter View Management, then click the Delete button to delete the view.
﻿
﻿
Caution
 Deleting a view will clear all data under the view and cannot be recovered. Please proceed with caution.