SHOW INTEGRATIONS¶

Lists the integrations in your account for which you have access privileges.

The output returns integration metadata and properties.

See also:: CREATE INTEGRATION , DROP INTEGRATION , ALTER INTEGRATION , DESCRIBE INTEGRATION

Syntax¶

SHOW [ { API | NOTIFICATION | SECURITY | STORAGE } ] INTEGRATIONS [ LIKE '<pattern>' ]

API | NOTIFICATION | SECURITY | STORAGE

Returns integrations of the specified type only.

LIKE 'pattern'

Filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...

... LIKE '%TESTING%' ...

Currently, only the API | NOTIFICATION | SECURITY | STORAGE parameter is supported.
The command does not require a running warehouse to execute.

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.

The command output provides table properties and metadata in the following columns:

| name | type | category | enabled | created_on |

Column	Description
`name`	Name of the integration
`type`	Type of the integration
`category`	Category of the integration
`enabled`	The current status of the integration, either TRUE (enabled) or FALSE (disabled)
`created_on`	Date and time when the integration was created

For more information about the properties that can be specified for an integration, see the following topic for the integration by type:

Show all notification integrations:

SHOW NOTIFICATION INTEGRATIONS;

Show all the integrations whose name starts with line that you have privileges to view:

SHOW INTEGRATIONS LIKE 'line%';