Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SHOW LINKS

Info

The SingleStore Managed Service does not support this command.

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 DB 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.

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 |
+------------------+----------------+------+--------------+