# SHOW LINKS

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                                    |
| `Config`      | Connection link configuration (JSON)                              |

## Remarks

* `db_name` is the name of the SingleStore 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 LINK`](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) permission. Contact your database administrator to grant this permission.
* See the [Permission Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

## Example

The following example displays the connection links to the `Orderdb` database:

```sql
SHOW LINKS ON Orderdb;

```

```output

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

```sql
SELECT * FROM INFORMATION_SCHEMA.LINKS;

```

```output

+---------------+------------+------+------------------------------+-----------------------------+
| DATABASE_NAME | LINK       | TYPE | DESCRIPTION                  | CONFIG                      |
+---------------+------------+------+------------------------------+-----------------------------+
| Orderdb       | product_S3 | S3   | Products ordered in December | {"region":"us-east-1"}      |
+---------------+------------+------+------------------------------+-----------------------------+

```

***

Modified at: February 18, 2026

Source: [/db/v9.1/reference/sql-reference/security-management-commands/show-links/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-links/)

(An index of the documentation is available at /llms.txt)