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.
The SingleStore Managed Service does not support this command.
Show all connection links on S3, Azure, GCS, HDFS, or Kafka for a permitted user.
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 |
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.SHOW LINK
permission. Contact your administrator to grant this permission.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 |
+------------------+----------------+------+--------------+