mc table view show

The mc table view show command displays metadata for an Iceberg view on an AIStor cluster.

The output includes the view schema, SQL definition, and properties.

Example

The following command displays metadata for the monthly_sales view in the prod namespace of the analytics warehouse on the myaistor AIStor cluster:

mc table view show myaistor analytics prod monthly_sales

Syntax

The command has the following syntax:

mc [GLOBALFLAGS] table view show ALIAS WAREHOUSE NAMESPACE VIEW

Brackets [] indicate optional parameters.
Parameters sharing a line are mutually dependent.
Parameters separated using the pipe | operator are mutually exclusive.

Copy the example to a text editor and modify as-needed before running the command in the terminal/shell.

Parameters

ALIAS

Required

The alias of an AIStor cluster.

NAMESPACE

Required

The name of the namespace containing the view.

VIEW

Required

The name of the view to display metadata for.

WAREHOUSE

Required

The name of the warehouse containing the view.

Global flags

This command supports any of the global flags.

Examples

Show view metadata

Use mc table view show to display view metadata:

mc table view show ALIAS WAREHOUSE NAMESPACE VIEW

Replace ALIAS with the alias of the AIStor cluster.
Replace WAREHOUSE with the name of the warehouse.
Replace NAMESPACE with the name of the namespace.
Replace VIEW with the name of the view.

Show view metadata with JSON output

Use the --json global flag to output the results in JSON format:

mc table view show myaistor analytics prod monthly_sales --json