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.

DROP LINK

Info

The SingleStore Managed Service does not support this command.

Remove a connection link on S3, Azure, GCS, HDFS, or Kafka for a permitted user.

Syntax

DROP LINK [db_name.]connection_name

Remarks

  • db_name is the name of the SingleStore DB database. It is an optional parameter. If not specified, the connection link is dropped from the current (context) database.
  • To drop a connection link, you need the DROP LINK permission. Contact your administrator to grant this permission.

Example

SHOW LINKS ON Orderdb;
****       
+-------------------------+--------+-----------------------------+
| Link                    | Type   | Description                 |
+-------------------------+--------+-----------------------------+
| product_S3              | S3     | Product list                |
| brand_S3                | S3     | Brand list                  |
+-------------------------+--------+-----------------------------+
DROP LINK Orderdb.brand_S3;

SHOW LINKS ON Orderdb;
****
+-------------------------+--------+-----------------------------+
| Link                    | Type   | Description                 |
+-------------------------+--------+-----------------------------+
| product_S3              | S3     | Product list                |
+-------------------------+--------+-----------------------------+