नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to:
Databricks SQL
Databricks Runtime 13.3 LTS and above
Unity Catalog only
Returns the metadata of an existing connection. The metadata information includes connection name, comment, owner and select options.
Syntax
{ DESC | DESCRIBE } CONNECTION connection_name
You can also specify SERVER instead of CONNECTION.
Parameters
- connection_name: The name of an existing connection in the Unity Catalog metastore. If the name does not exist, an exception is thrown.
Returns
A report with the following rows:
- name: The name of the connection.
- Connection Type: The type of the connection.
- Credential Type: The type of the credential (e.g.
username_password) - Url: The URL of the remote server.
- Owner: The principal that owns the connection.
- Created At: The timestamp when the connection was created, in
ISO 8601format. - Created By: The principal who created the connection.
- Comment: User specified comments, if any.
- Options: A selective list of options that are considered safe to display.
Examples
> DESCRIBE CONNECTION postgresql_connection;
---- ---------------------
name postgresql_connection
Connection Type postgresql
Credential Type username_password
Url jdbc://...
Owner alf@melmak.et
Created At 2022-01-01T00:00:00.000+0000
Created By alf@melmak.et
Comment This is a postgresql connection
Options ((host, '...'), (port, '5432'), ...)