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