Categories:
User & Security DDL (Third-Party Service Integrations)

DESCRIBE SECURITY INTEGRATION

Describes the properties of an integration, including the following:

  • Authorization and token endpoints
  • Client ID
  • Blocked roles

DESCRIBE can be abbreviated to DESC.

See also:
ALTER SECURITY INTEGRATION , CREATE SECURITY INTEGRATION , SHOW INTEGRATIONS

Syntax

DESC[RIBE] [ SECURITY ] INTEGRATION <name>

Parameters

name
Specifies the identifier for the integration to describe. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage Notes

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Examples

Create an example integration:

CREATE SECURITY INTEGRATION myint ( ... );

Describe the columns in the integration:

DESC SECURITY INTEGRATION myint;