Categories:

Account & Session DDL

SHOW CONNECTIONS

Lists the connections for which you have access privileges.

The output returns connection metadata and properties, ordered by connection name (see Output in this topic for descriptions of the output columns). This is important to note if you wish to filter the results using the provided filters.

See also:

CREATE CONNECTION , DROP CONNECTION

Syntax

SHOW CONNECTIONS [ LIKE '<pattern>' ]

Parameters

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

Usage Notes

  • 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.

  • Only account administrators (users with the ACCOUNTADMIN role) can execute this SQL command.

Output

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

| snowflake_region | created_on | account_name | name | comment | is_primary | primary | failover_allowed_to_acounts | connection_url | organization_name | account_locator

The command output for organizations that span multiple region groups includes an additional region_group column:

| region_group | snowflake_region | created_on | account_name | name | comment | is_primary | primary | failover_allowed_to_acounts | connection_url | organization_name | account_locator

Column

Description

region_group

Region group where the account is located. Note: this column is only displayed for organizations that span multiple region groups.

snowflake_region

Snowflake Region where the account is located. A Snowflake Region is a distinct location within a cloud platform region that is isolated from other Snowflake Regions. A Snowflake Region can be either multi-tenant or single-tenant (for a Virtual Private Snowflake account).

created_on

Date and time when the connection was created.

account_name

Name of the account. An organization administrator (i.e. a user with the ORGADMIN role) can change the account name.

name

Name of the connection.

comment

Comment for the connection.

is_primary

Indicates whether the connection is a primary connection.

primary

Organization name, account name, and connection name of the primary connection. This value can be copied into the AS REPLICA OF clause of the CREATE CONNECTION command when creating secondary connections.

failover_allowed_to_accounts

A list of any accounts that the primary connection can redirect to.

connection_url

Connection URL that users pass to a client to establish a connection to Snowflake.

organization_name

Name of your Snowflake organization.

account_locator

Account locator in a region.

For more information about the properties that can be specified for a connection, see CREATE CONNECTION.

Examples

Show all the connections whose name starts with test:

SHOW CONNECTIONS LIKE 'test%';