DROP LINK

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 database. It is an optional parameter. If not specified, the connection link is dropped from the current (context) database.

  • This command causes implicit commits. Refer to COMMIT for more information.

  • To drop a connection link, you need the DROP LINK permission. Contact your administrator to grant this permission.

  • Refer to the Permission Matrix for the required 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                |
+-------------------------+--------+-----------------------------+

Last modified: August 18, 2023

Was this article helpful?