DROP TRANSFER

The DROP TRANSFER statement deletes a transfer instance. If a consumer was created automatically when the transfer was created, it is also deleted. The system will keep trying to delete the consumer until the operation is successful.

The DROP TRANSFER statement does not delete the destination table or the source topic.

Syntax

DROP TRANSFER <name>

where:

• name — the name of the transfer instance.

Permissions

The following permissions are required to delete a transfer:

• REMOVE SCHEMA — to delete the transfer instance;
• ALTER SCHEMA — to delete the automatically created topic consumer (if applicable).

Examples

The following query deletes the transfer named my_transfer:

DROP TRANSFER my_transfer;

See Also

• CREATE TRANSFER
• ALTER TRANSFER
• Data transfer