Skip to main content

SHOW VIEWS

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

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

Parameters​

AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <reference_name> 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