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