# 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

```sql
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

```sql
SELECT * FROM deltastream.sys."stores";
```

```sh
[{"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":"user@example.com","created_at":"2026-02-26T17:52:13.837Z","updated_by_role":"sysadmin","updated_by_role_deleted":false,"updated_by":"user@example.com","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":"user@example.com","created_at":"2025-06-05T20:17:32.98Z","updated_by_role":"sysadmin","updated_by_role_deleted":false,"updated_by":"user@example.com","updated_at":"2025-06-05T20:17:32.98Z","organization_id":"00000000-0000-0000-0000-000000000001"}]
```

Filter stores by type:

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

## See Also

* [System Tables Overview](https://docs.deltastream.io/reference/sql-syntax/systables)
* [LIST STORES](https://docs.deltastream.io/reference/sql-syntax/command/list-stores)
* [CREATE STORE](https://docs.deltastream.io/reference/sql-syntax/ddl/create-store)