DESCRIBE CONNECTION
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 8601
format. - 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'), ...)
Related articles
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για