DESCRIBE STORE

Syntax

DESCRIBE STORE store_name;

Description

This provides the definition of an existing Store.

Stores will only be listed if the current role has USAGE privileges.

Arguments

store_name

This is the name of the Store to describe. For case-sensitive names, the name must be wrapped in double quotes; otherwise, the lowercase name will be used.

Examples

Describe a Store

The following describes the Store named demostore:

demodb.analytics/demostore# DESCRIBE STORE demostore;
    Name   | Type  | Access region | Metadata |      URIs      | TLS | Verify host | TLS protocols | Chiphers | Additional egress URIs | Schema registry |  Owner   |      Created at      |      Updated at       
-----------+-------+---------------+----------+----------------+-----+-------------+---------------+----------+------------------------+-----------------+----------+----------------------+-----------------------
 demostore | Kafka | LOC us-cent-1 | {}       | b-1.kafka:9196 | ✓   | ✓           |               |          |                        |                 | sysadmin | 2023-02-13T18:00:07Z | 2023-02-16T23:48:37Z  
           |       |               |          | b-2.kafka:9196 |     |             |               |          |                        |                 |          |                      |                       
           |       |               |          | b-3.kafka:9196 |     |             |               |          |                        |                 |          |                      |                       

Describe a case-sensitive Store

The following describes the Store named DemoStore:

demodb.analytics/demostore# DESCRIBE STORE "DemoStore";
    Name   | Type  | Access region | Metadata |      URIs      | TLS | Verify host | TLS protocols | Chiphers | Additional egress URIs | Schema registry |  Owner   |      Created at      |      Updated at       
-----------+-------+---------------+----------+----------------+-----+-------------+---------------+----------+------------------------+-----------------+----------+----------------------+-----------------------
 DemoStore | Kafka | LOC us-cent-1 | {}       | b-1.kafka:9196 | ✓   | ✓           |               |          |                        |                 | sysadmin | 2023-02-13T18:00:07Z | 2023-02-16T23:48:37Z  
           |       |               |          | b-2.kafka:9196 |     |             |               |          |                        |                 |          |                      |                       
           |       |               |          | b-3.kafka:9196 |     |             |               |          |                        |                 |          |                      |