tencent cloud

Tencent Cloud WeData

ドキュメントTencent Cloud WeDataOperation GuideProject ManagementSystem CatalogBasic System Tables

Basic System Tables

PDF
フォーカスモード
フォントサイズ
最終更新日: 2025-12-29 14:54:10
This article introduces the system tables of the basic module, which record the data of the basic module under the account. You can access the system tables directly to view historical data or process table data for analysis scenarios.

Usage Requirements

Access system catalog must use DLC Data Source. Other data sources do not support system catalog.
Access system catalog must use tc-catalog.

Existing System Table

Table name
Description(Optional)
Update Frequency
data_source
Contains data source information.
Update every 5 minutes

data_source

Table system_catalog.wedata.data_source
Table structure:
Column Name
Data Type
Description(Optional)
datasource_id
string
data source ID
project_id
string
Project ID
project_name
string
Project Name
data_source_name
string
Task ID
data_source_type
string
Supported Data Source Type
type
string
Type:
CLUSTER: system source
DB: custom definition source
display_name
string
Displayed Name
description
string
Description(Optional)
associated_project
string
Data source ownership project
creator
string
Created by
authorized_project
string
Data source authorization project
create_timestamp
long
Creation time.
update_timestamp
long
Last update time.
update_user
string
Last updated by
Query Example:
#Query data source information for a specific project
SELECT 
    datasource_id,  
    data_source_name, 
    data_source_type, 
    type, 
    display_name
FROM 
    wedata.data_source
WHERE 
    project_id = 'your_project_id';  -- Replace with your project ID

#Query the authorized projects of a specific data source
SELECT 
    authorized_project
FROM 
    wedata.data_source
WHERE 
    datasource_id = 'your_datasource_id';  -- -- Replace with your datasource ID

前の記事へ: Development and Ops System Tables次の記事へ: Variable Settings

ヘルプとサポート

この記事はお役に立ちましたか？

フィードバック