Dremio Cloud
Dremio Software
 
On this page

    Showing a View

    Show all the views that are available in an Arctic catalog.

    Syntax 
    SHOW VIEWS
  [ AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <refValue> ]
  [ IN <catalog_name> ]

    Parameters

    AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <refValue>

    String

    Optional

    Specify a reference for which you want to show the view:

    • REF: Identifies the branch, tag, or commit that you want to show the available view from.

    • BRANCH: Shows the available views in the specified branch.

    • TAG: Shows the available views in the specified tag.

    • COMMIT: Shows the available views in the specified commit. Commit hashes must be enclosed in double quotes (for example, “ff2fe50fef5a030c4fc8e61b252bdc33c72e2b6f929d813833d998b8368302e2”).

    IN <catalog_name>

    String

    Optional

    The name of the Arctic catalog used. When this parameter is omitted, the current Arctic catalog in the query context is used.

    Examples

    Show the available views in the current Arctic catalog 
    SHOW VIEWS
    Show the available views in a specified reference in the current catalog 
    SHOW VIEWS
   AT REF myBranch
    Show the available views in a specified reference in the specified catalog 
    SHOW VIEWS
   AT BRANCH myBranch
   IN myCatalog