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

1. 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)