SHOW LINKS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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 |
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 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