Retrieves the details of a specific table or all tables in a database within a specified catalog.
Try it now
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
stream:GetTables |
get |
*All Resource
|
None |
None |
Request syntax
GET /api/v2/namespaces/{namespace}/catalogs/{catalogName}/databases/{databaseName}/tables HTTP/1.1
Path Parameters
|
Parameter |
Type |
Required |
Description |
Example |
|
namespace |
string |
Yes |
The name of the namespace. |
u-gs3rgla9-default |
|
catalogName |
string |
Yes |
The name of the catalog. |
paimon |
|
databaseName |
string |
Yes |
The name of the database. |
paimon-ods |
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
|
workspace |
string |
Yes |
The workspace ID. |
a14bd5d90a**** |
|
tableName |
string |
No |
The name of the table. If this parameter is left empty, information about all tables is returned. |
item |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
The response data. |
||
|
requestId |
string |
The request ID. |
ECE641B2-AB0B-4174-9C3B-885881558637 |
|
success |
boolean |
Indicates whether the request was successful. |
true |
|
httpCode |
integer |
The business status code. This is always 200. Use the success parameter to determine whether the request was successful. |
200 |
|
errorCode |
string |
|
"" |
|
errorMessage |
string |
|
"" |
| data |
array |
If success is true, a list of tables that meet the criteria and their details are returned. If success is false, this parameter is empty. |
|
|
The table information. |
Examples
Success response
JSON format
{
"requestId": "ECE641B2-AB0B-4174-9C3B-885881558637",
"success": true,
"httpCode": 200,
"errorCode": "\"\"",
"errorMessage": "\"\"",
"data": [
{
"name": "order-test",
"schema": {
"columns": [
{
"name": "name",
"metadataInfo": {
"key": "topic",
"virtual": true
},
"expression": """",
"type": "string",
"nullable": true
}
],
"watermarkSpecs": [
{
"column": "time",
"watermarkExpression": "INTERVAL '5' SECOND"
}
],
"primaryKey": [
{
"constraintName": "pk",
"columns": [
"id"
]
}
]
},
"properties": {
"test": "test",
"test2": 1
},
"comment": "Test order table",
"partitionKeys": [
"ad=xxxxx"
]
}
]
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.