SHOW CATALOG INTEGRATIONS¶

Lists the catalog integrations in your account. The output returns integration metadata and properties.

See also:

CREATE CATALOG INTEGRATION , ALTER CATALOG INTEGRATION , DROP CATALOG INTEGRATION , DESCRIBE CATALOG INTEGRATION

Syntax¶

SHOW CATALOG INTEGRATIONS [ LIKE '<pattern>' ]
Copy

Parameters¶

LIKE 'pattern'

Optionally 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%' ...

. Default: No value (no filtering is applied to the output).

Access control requirements¶

A role used to execute this SQL command must have at least one of the following privileges at a minimum:

Privilege

Object

Notes

USAGE

Integration

OWNERSHIP

Integration

OWNERSHIP is a special privilege on an object that is automatically granted to the role that created the object, but can also be transferred using the GRANT OWNERSHIP command to a different role by the owning role (or any role with the MANAGE GRANTS privilege).

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.

Usage notes¶

  • The command doesn’t 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.

Output¶

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

Column

Description

name

Name of the catalog integration.

enabled

Specifies whether the catalog integration is available to use for Apache Icebergâ„¢ tables.

type

Type of the integration. The value is always CATALOG.

category

Category of the integration. The value is always CATALOG.

comment

String (literal) that specifies a comment for the integration.

created_on

Date and time when the catalog integration was created.

For more information about the properties that can be specified for a catalog integration, see CREATE CATALOG INTEGRATION.

Examples¶

Show all catalog integrations:

SHOW CATALOG INTEGRATIONS;
Copy

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

SHOW CATALOG INTEGRATIONS LIKE 'demo%';
Copy