SHOW LINKS
Show all connection links on S3, Azure, GCS, HDFS, or Kafka for a permitted user.
Syntax
SHOW LINKS [ON db_name]
Output
Column | Description |
|---|---|
| Name of the connection link provided at the time of link creation |
| Type of connection link - S3, Azure, GCS, HDFS, or Kafka |
| Details of the connection link |
Remarks
db_nameis the name of the SingleStoreDB database. It is an optional parameter. If not specified, the connection links in the current (context) database are displayed.To view and use connection links, you need the
SHOW LINKpermission. Contact your administrator to grant this permission.See the Permission Matrix for the required permission.
Example
The following example displays the connection links to the Orderdb database:
SHOW LINKS ON Orderdb; **** +-------------------------+--------+-----------------------------+ | Link | Type | Description | +-------------------------+--------+-----------------------------+ | product_S3 | S3 | Product list | +-------------------------+--------+-----------------------------+
You can also query the information schema to view all links in the cluster, along with the link details.
SELECT * FROM INFORMATION_SCHEMA.LINKS; **** +------------------+----------------+------+--------------+ | DATABASE_NAME | LINK | TYPE | DESCRIPTION | +------------------+----------------+------+--------------+ | Orderdb | product_s3 | S3 | Product list | +------------------+----------------+------+--------------+