DROP LINK
On this page
Remove a connection link on S3, Azure, GCS, HDFS, or Kafka for a permitted user.
Syntax
DROP LINK [db_name.]connection_nameRemarks
-
db_is the name of the SingleStore database.name 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 LINKpermission.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