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