The DataWorks data catalog provides a unified interface to manage AnalyticDB for PostgreSQL instance metadata. Use it to register data sources, create and manage tables — all within Data Studio.
Go to the AnalyticDB PostgreSQL data catalog page
Go to the Workspaces page in the DataWorks console. In the top navigation bar, select the desired region. Find the desired workspace and choose Shortcuts > Data Studio in the Actions column.
Click the
icon in the left navigation pane. In the Data Catalog directory tree, click AnalyticDB PostgreSQL.
Create an AnalyticDB PostgreSQL data catalog
Add existing AnalyticDB PostgreSQL data sources as datasets to the data catalog list.
Click the
icon next to the AnalyticDB PostgreSQL data catalog to open the Add Instance page.On the DataWorks Data Source tab, add the AnalyticDB PostgreSQL data source to the data catalog:
To add a single data source: locate the existing AnalyticDB PostgreSQL data source on the DataWorks Data Source tab and click Add in the Actions column.
To add multiple data sources at once: select them on the DataWorks Data Sources tab and click Batch Add.
Manage an AnalyticDB PostgreSQL data catalog
Add and manage tables in an AnalyticDB PostgreSQL data catalog.
Create a table
Before creating a table, make sure the AnalyticDB for PostgreSQL instance is added to the data catalog. See Create an AnalyticDB PostgreSQL data catalog.
Click the
icon to the left of the AnalyticDB for PostgreSQL instance and locate Table in the database.Click the
icon to the right of Table to open the Create Table page.Generate the basic table and field information using one of the following methods.
Copilot Create Table (recommended for quickly generating a table structure from a natural language description):
Click Copilot Create Table in the toolbar at the top of the page to open the Copilot Chat interface.
Enter an instruction in natural language. For example:
Create a table for daily user purchase details.Click Generate And Replace. The system generates a default table name and field information based on your instruction.
Click Accept if the table name and fields are correct.
NoteAfter clicking Accept, you can still manually edit the generated information.
Create a table manually (recommended when you need precise control over field types and definitions):
Configure the following parameters.
Parameter Description Basic information Customize information such as Table Name and Table Description. Field information Add and configure fields and field annotations. Click Insert above the field list to manually specify the number of rows to insert and edit information such as the field name and field type. Alternatively, click Generate Fields or Generate Field Descriptions to let Copilot generate fields and descriptions based on the table name and table description.
Click Publish in the toolbar to create the table.
Manage tables
View a table
Click the icon to the left of the AnalyticDB for PostgreSQL data catalog, then click Table to view basic table information on the Table list page. Click a table name to open the table details page and view Fields and DDL.
Modify a table
On the table details page, click Edit in the upper-right corner. Update the Fields or Description, then click Publish to apply the changes.
Delete a table
On the Tables page, find the table and click Delete in the Actions column. Click Confirm in the dialog box.
Deleting a table cannot be undone. Proceed with caution.
View and detach an AnalyticDB PostgreSQL data catalog
If you no longer need a registered AnalyticDB PostgreSQL data source, view its details or detach it from the data catalog.
View a data source
Click the
icon to the left of the data catalog to expand the instance list.Hover over an AnalyticDB for PostgreSQL instance to view the Cluster ID and Cluster Type.
Detach the data catalog
Right-click the data catalog and select Detach Data Catalog.