DROP LINK
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Remove a connection link on S3, Azure, GCS, HDFS, or Kafka for a permitted user.
Syntax
DROP LINK [db_name.]connection_name
Remarks
-
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 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