SHOW CONNECTIONS

Lists all registered external connections, optionally filtered by a LIKE substring.

Category: configurationPrivilege: adminDeltaForge extension

Syntax

SHOW CONNECTIONS [LIKE '<pattern>']

Description

## Overview SHOW CONNECTIONS enumerates external_connections. Sensitive option values are masked server-side before the response is returned; secret material referenced via credential_id is never included. ## Behavior - Each row includes name, connection_type, and a status derived from last_test_success (ok / failed / untested). - Inactive or never-tested connections are returned alongside active ones. - The LIKE filter is applied as a case-insensitive substring match on name. - Output is a plain multi-line text message in v1. Arrow RecordBatch output is tracked separately. ## Access Control Requires the admin role. The Control Plane enforces connections:read on GET /connections. ## Compatibility DeltaForge extension.

Parameters

Name	Type	Description
`like_pattern`		Specifies a case-insensitive substring filter on connection name. Not a standard SQL LIKE; substring match for parity with the GUI filter.

Examples

-- List every connection
SHOW CONNECTIONS;

-- Filter by environment or prefix
SHOW CONNECTIONS LIKE 'prod_';

-- Filter by vendor
SHOW CONNECTIONS LIKE 's3';

Pitfalls

LIKE is a case-insensitive substring match, not a standard SQL LIKE. Wildcards like '%' are treated literally.
Status column reflects the last TEST CONNECTION run, not current reachability. A connection can appear 'ok' but fail at query time because credentials rotated or the target system went down after the last test.
The output is not currently an Arrow RecordBatch. SELECT * FROM (SHOW CONNECTIONS) does not work in v1.