View Connection Details
This feature allows users to query detailed information of a created Connection object, including its properties, configuration, etc.
Syntax
{ DESC | DESCRIBE } CONNECTION [ EXTENDED ] connection_name
Parameter Description
- EXTENDED: Optional keyword to display the property information used when creating the Connection. When this keyword is added, the query result will contain more detailed property information.
- connection_name: The name of the created Connection.
Example
-
Query the basic information of a Connection named my_connection:
DESC CONNECTION catalog_storage_oss;
+--------------------+---------------------------------------+
| info_name | info_value |
+--------------------+---------------------------------------+
| name | catalog_storage_oss |
| creator | UAT_TEST |
| created_time | 2024-12-14 20:09:40.146 |
| last_modified_time | 2024-12-14 20:09:40.146 |
| comment | |
| properties | () |
| type | OSS |
| enabled | ENABLED |
| ACCESS_ID | xxxxxt7xb8NouiqLrjfnC1xx |
| ENDPOINT | oss-cn-hangzhou-internal.aliyuncs.com |
+--------------------+---------------------------------------+
10 rows selected (0.274 seconds)
