Data Lake Compute (DLC) provides data view query capabilities, allowing users to quickly and conveniently query and use data by managing data views.
Creating a View
1. Log in to the DLC console and select the service region. Ensure the logged-in user has the permission to create views. 2. Go to the Data Exploration page and create a view using SQL statements. For details on the syntax, see SQL Syntax. 3. Select the computing resources and click the Run button to complete the view creation.
Viewing a View
You can view a view using SQL statements in Data Exploration. For detailed syntax, see SQL syntax. DLC also provides a visual interface for managing views. The steps are as follows: 1. Log in to the DLC console and select the service region. Ensure the logged-in user has the permission to query views. 2. Go to the data management page and click the Database Name where the view is located to enter the database management center page.
3. Click View to enter view management.
4. Click the View Name you want to see to view the view information, and you can copy the SQL statements.
Deleting a View
You can delete a view using SQL statements in Data Exploration. For detailed syntax, see SQL syntax. DLC also provides a visual interface for managing views. The steps are as follows. 1. Log in to the DLC Console and select the service region, and ensure the logged-in user has the permission to delete views. 2. Go to the data management page and click on the Database Name where the view is located to enter the database management center page.
3. Click View to enter view management, then click the Delete button to delete the view.
Note
Deleting a view will clear all data under the view and cannot be recovered. Please operate with caution.