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

Link

Name of the connection link provided at the time of link creation

Type

Type of connection link - S3, Azure, GCS, HDFS, or Kafka

Description

Details of the connection link

Remarks

  • db_name is the name of the SingleStore 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 LINK permission. 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 |
+------------------+----------------+------+--------------+

Last modified: August 18, 2023

Was this article helpful?