DeltaStream
Search
K
Comment on page

LIST STORES

Syntax

{ LIST | SHOW } STORES;

Description

This provides a list of Stores that the user has access to.
Stores will only be listed if the current role has USAGE privileges.

Examples

List Stores

The following provides a list of Stores the current user has access to:
demodb.public/msk_public# LIST STORES;
Name | Kind | Access Region | Metadata | Owner | Created at | Updated at
---------------+---------+---------------+----------+----------+----------------------+-----------------------
kinesis_main | Kinesis | AWS us-east-1 | {} | sysadmin | 2023-01-10T19:34:41Z | 2023-01-10T19:34:41Z
msk_public | Kafka | AWS us-east-1 | {} | sysadmin | 2023-01-12T20:38:16Z | 2023-01-12T20:38:16Z