stores

Description

Exposes metadata about stores (external system connections) in the organization. Credential values are never exposed — only whether credentials are configured (has_credentials). Only stores on which the current role has USAGE privileges are returned.

Syntax

SELECT ... FROM deltastream.sys."stores";

Columns

Column	Type	Nullable	Description
name	VARCHAR	No	Name of the store.
type	VARCHAR	No	Type of the store. One of Kafka, Kinesis, Snowflake, Databricks, PostgreSQL, ClickHouse, S3, IcebergAWSGlue, IcebergRest.
uris	VARCHAR	No	JSON array of URIs for the store connection.
ssl_enabled	BOOLEAN	No	Whether TLS/SSL is enabled for the store connection.
hostname_verification	BOOLEAN	No	Whether server hostname verification is enabled.
has_credentials	BOOLEAN	No	Whether credentials are configured for the store. The credential values themselves are never exposed.
schema_registry	VARCHAR	Yes	Name of the schema registry associated with the store, if any.
properties	VARCHAR	Yes	JSON object of additional store properties.
details	VARCHAR	No	JSON object of store-type-specific details (e.g. account ID, region).
status	VARCHAR	No	Current connectivity status of the store. One of ready, error.
status_message	VARCHAR	Yes	Error message if status is error.
marked_for_deletion	BOOLEAN	No	Whether the store is pending deletion.
owner	VARCHAR	No	The role that owns this resource.
created_by_role	VARCHAR	No	The role that created this resource.
created_by_role_deleted	BOOLEAN	No	Whether the creating role has since been deleted.
created_by	VARCHAR	No	The user that created this resource.
created_at	TIMESTAMP_LTZ	No	Timestamp when this resource was created.
updated_by_role	VARCHAR	No	The role that last updated this resource.
updated_by_role_deleted	BOOLEAN	No	Whether the last updating role has since been deleted.
updated_by	VARCHAR	No	The user that last updated this resource.
updated_at	TIMESTAMP_LTZ	No	Timestamp when this resource was last updated.
organization_id	VARCHAR	No	The unique identifier of the organization this resource belongs to.

Examples

SELECT * FROM deltastream.sys."stores";

[{"name":"aml","type":"Kafka","uris":"[\"pkc-921jm.us-east-2.aws.confluent.cloud:9092\"]","ssl_enabled":true,"hostname_verification":false,"has_credentials":true,"schema_registry":null,"properties":"{}","details":"{}","status":"ready","status_message":null,"marked_for_deletion":false,"owner":"sysadmin","created_by_role":"sysadmin","created_by_role_deleted":false,"created_by":"[email protected]","created_at":"2026-02-26T17:52:13.837Z","updated_by_role":"sysadmin","updated_by_role_deleted":false,"updated_by":"[email protected]","updated_at":"2026-02-26T18:04:58.065Z","organization_id":"00000000-0000-0000-0000-000000000001"},{"name":"badkstore","type":"Kinesis","uris":"[\"https://kinesis.us-east-2.amazonaws.com:443\"]","ssl_enabled":true,"hostname_verification":true,"has_credentials":true,"schema_registry":null,"properties":null,"details":"{\"account_id\":\"792739327446\",\"region_code\":\"us-east-2\"}","status":"ready","status_message":null,"marked_for_deletion":false,"owner":"sysadmin","created_by_role":"sysadmin","created_by_role_deleted":false,"created_by":"[email protected]","created_at":"2025-06-05T20:17:32.98Z","updated_by_role":"sysadmin","updated_by_role_deleted":false,"updated_by":"[email protected]","updated_at":"2025-06-05T20:17:32.98Z","organization_id":"00000000-0000-0000-0000-000000000001"}]

Filter stores by type:

SELECT name, type, status FROM deltastream.sys."stores" WHERE type = 'Kafka';

See Also

• System Tables Overview

• LIST STORES

• CREATE STORE