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