Important
The SingleStore 9.1 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 9.1.
SHOW LINKS
On this page
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 |
|
|
Connection link configuration (JSON) |
Remarks
-
db_is the name of the SingleStore database.name 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 database 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 | Config |
+-------------------+------+---------------------------------+------------------------+
| product_S3 | S3 | Products ordered in December | {"region":"us-east-1"} |
+-------------------+------+---------------------------------+------------------------+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 | CONFIG |
+---------------+------------+------+------------------------------+-----------------------------+
| Orderdb | product_S3 | S3 | Products ordered in December | {"region":"us-east-1"} |
+---------------+------------+------+------------------------------+-----------------------------+Last modified: February 18, 2026