mc table view exists

The mc table view exists command checks if an Iceberg view exists in the catalog on an AIStor cluster.

Example

The following command checks if the monthly_sales_view view exists in the prod namespace of the analytics warehouse on the myaistor AIStor cluster:

mc table view exists myaistor analytics prod monthly_sales_view

Syntax

The command has the following syntax:

mc [GLOBALFLAGS] table view exists 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 to check.

VIEW

Required

The name of the view to check for existence.

WAREHOUSE

Required

The name of the warehouse containing the namespace.

Global flags

This command supports any of the global flags.

Examples

Check if a view exists

Use mc table view exists to check for a view:

mc table view exists 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 to check.

Check with JSON output

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

mc table view exists myaistor analytics prod monthly_sales_view --json