tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud WeData
    Documentation
    Download PDF

    Database and Table Management

    Last updated: 2024-11-01 16:12:15
    Download PDF
      Note:
      The Database and Table Management feature will be decommissioned soon.
      Database and Table Management page supports managing databases, tables, views, and other data objects in the enterprise data warehouse. Only administrators can perform CRUD operations on databases.

      Database list

      The database list shows the databases that have been created. Users can click the database name to enter the Data Table list and View list.
      
      
      
      Information
      Description
      Database name
      Database name
      Data Source
      Data source to which the database belongs
      Data Source Type
      Database Type
      Created by
      Database creator
      Creation Time
      Database creation time
      Operation
      Feature that supports deleting databases

      Table list

      On the database list page, click the database name and select the table interface to see all tables in the current database. It also supports features to transfer table ownership, modify lifecycles, and set thematic categories.
      
      
      
      Enter the Database and Table Management > Data Table page. Regular users can only manage tables they are responsible for, while project administrators can manage and maintain all tables.
      
      
      
      Information
      Description
      Table name
      Table English name
      Table Owner
      Owner of the corresponding data table
      Environment
      Mark the table as a production environment or development environment data table
      Layer
      Business Layering of the data table
      Storage Capacity
      Physical storage size of the data table
      Popularity
      Popularity = Routine task access + Ad hoc query access
      1. Routine task access = count(distinct task, day)
      2. Ad hoc query access = count(distinct user, day)
      3. Only includes read operations for the past 7 days, updated daily
      Lifecycle
      Expiration Policy
      1. Data expiration: This refers to when the last change time of the data exceeds the set lifecycle from today (for partition tables, the last change time of partitioned data is assessed)
      2. Starting 7 days before data expiration, the system will send a daily expiration reminder to the table owner (effective the day after modifying the lifecycle)
      3. Based on the "expiration prompt", you can manually delete tables from the management page or clean up expired partition data to save on cold data storage usage
      Creation Time
      Data table creation time
      Operation
      Supports deletion, modification of lifecycle data table operation feature

      Batch operation

      Batch Transfer

      Go to Database and Table Management > Data Table page, check the data tables to be transferred, click Batch Submit, you can batch transfer the data table permissions to other users and change the table owner.
      
      
      

      Batch Modify Lifecycle

      Go to Database and Table Management > Data Table page, check the data tables to be modified, click Batch Modify Lifecycle, you can batch modify the lifecycle of data tables.
      
      
      

      Batch Set Asset Catalog

      Go to Database and Table Management > Data Table page, check the data tables to be modified, click Batch Set Topic Catalogory, you can set the business topic catagory for the data tables.
      
      
      

      View

      Go to Database and Table Management > View page, project members can view the view under the database, but creation is not supported for now.
      
      
      
      
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy