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_nameis 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 LINKpermission. 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 |
+------------------+----------------+------+--------------+
