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

Was this Article Helpful?

Questions?

Ask the Community, find solutions in the Troubleshooting Overview, get Self-Paced Training or learn more about our Support Plans.