Skip to main content
show_statistics(table_names=None, options=)[source]

Retrieves the collected column statistics for the specified table(s).

Parameters

table_names (list of str) –

Names of tables whose metadata will be fetched, each in [schema_name.]table_name format, using standard name resolution rules. All provided tables must exist, or an error is returned. A single entry of ‘*’ expands to every user table the caller may read (excluding system schemas, views, and temporary tables); when used it must be the only entry. The user can provide a single element (which will be automatically promoted to a list internally) or a list.

options (dict of str to str) –

Optional parameters. Allowed keys are:

  • no_error_if_not_exists – If true and if the table names specified in input parameter table_names does not exist, no error is returned. If false and if the table names specified in input parameter table_names does not exist, then an error is returned. Allowed values are:

    • true

    • false

    The default value is ‘false’.

The default value is an empty dict ( ).

Returns

A dict with the following entries–

table_names (list of str) –

Value of input parameter table_names.

stastistics_map (list of lists of dicts of str to str) –

A list of maps which contain the column statistics of the table input parameter table_names.

info (dict of str to str) –

Additional information.