ALTER RECIPIENT (Databricks SQL)

Renames a recipient. Transfers the ownership of a recipient to a new principal.

Syntax

ALTER RECIPIENT recipient_name
  { RENAME TO to_recipient_name |
    [ SET ] OWNER TO principal }

Parameters

  • recipient_name

    The name of the recipient to be altered.

  • RENAME TO to_recipient_name

    Renames the recipient. The name must be unique among all recipients in the metastore. To run this statement, you must be the owner of the recipient and have CREATE RECIPIENT privilege on the metastore.

  • [ SET ] OWNER TO principal

    Transfers ownership of the recipient to principal. To run this statement, you must be the owner of the recipient.

    SET is allowed as an optional keyword. Requires: SQL warehouse version 2022.35 or higher. This version is available in the Preview channel.

Examples

-- Rename a recipient
> ALTER RECIPIENT `Center for Disease Control` RENAME TO cdc;

-- Change ownership of the recipient
> ALTER RECIPIENT cdc OWNER TO `alf@melmak.et`