tencent cloud

Tencent Cloud WeData

Release Notes
Dynamic Release Record (2026)
Product Introduction
Product Overview
Product Advantages
Product Architecture
Product Features
Application Scenarios
Purchase Guide
Billing Overview
Product Version Purchase Instructions
Execute Resource Purchase Description
Billing Modes
Overdue Policy
Refund
Preparations
Overview of Account and Permission Management
Add allowlist /security groups (Optional)
Sign in to WeData with Microsoft Entra ID (Azure AD) Single Sign-On (SSO)
Operation Guide
Console Operation
Project Management
Data Integration
Studio
Data Development
Data Analysis
Data Science
Data Governance (with Unity Semantics)
API Documentation
History
Introduction
API Category
Making API Requests
Smart Ops Related Interfaces
Project Management APIs
Resource Group APIs
Data Development APIs
Data Asset - Data Dictionary APIs
Data Development APIs
Ops Center APIs
Data Operations Related Interfaces
Data Exploration APIs
Asset APIs
Metadata Related Interfaces
Task Operations APIs
Data Security APIs
Instance Operation and Maintenance Related Interfaces
Data Map and Data Dictionary APIs
Data Quality Related Interfaces
DataInLong APIs
Platform Management APIs
Data Source Management APIs
Data Quality APIs
Platform Management APIs
Asset Data APIs
Data Source Management APIs
Data Types
Error Codes
WeData API 2025-08-06
Service Level Agreements
Related Agreement
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary
DokumentasiTencent Cloud WeDataOperation GuideProject ManagementSystem CatalogBasic System Tables

Basic System Tables

PDF
Mode fokus
Ukuran font
Terakhir diperbarui: 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

Topik sebelumnya: Development and Ops System TablesTopik selanjutnya: Variable Settings

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan