DESCRIBE EXTERNAL CONSUMER

Describes an external consumer, including its properties and current configuration.

DESCRIBE can be abbreviated to DESC.

See also:

CREATE EXTERNAL CONSUMER , ALTER EXTERNAL CONSUMER , DROP EXTERNAL CONSUMER , SHOW EXTERNAL CONSUMERS

Syntax

{ DESC | DESCRIBE } EXTERNAL CONSUMER <name>

Parameters

name

Specifies the identifier for the external consumer to describe.

Access control requirements

A role used to execute this operation must have the following privileges at a minimum:

PrivilegeObjectNotes
OWNERSHIP or USAGEExternal ConsumerRequired to describe the external consumer.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Examples

Describe an external consumer:

DESC EXTERNAL CONSUMER acme_consumer;