Views

The views system table includes information about the materialized views that have been created within your organization.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.information_schema.views;

The system.information_schema.views table includes the following columns:

Column	Type	Description
catalog	string	The name of the catalog used to store the view.
comment	string	An optional comment to describe the view.
created_at	datetime	The date and time when the view was created.
created_by	string	The name of the user who created the view.
id	string	The unique identifier for the view.
modified_at	datetime	The date and time when the view was modified.
modified_by	string	The name of the user who modified the view.
name	string	The name of the materialized view.
properties	string	See the Properties table below.
schema	string	The name of the schema used to store the view.

Properties

The properties column comprises information about the options specified when the materialized view was created:

Column	Type	Description
COMMENT	string	An optional comment to describe the view.
COMPUTE_CLUSTER	string	The compute cluster that runs the view.
MAX_TIME_TRAVEL_DURATION	integer	The number of days the state information maintained by the materialized view should be retained.
STORAGE_CONNECTION	string	The storage connection of the first table in the FROM statement in the view.
STORAGE_LOCATION	string	The storage location of the first table in the FROM statement in the view.
WINDOW	string	The maximum number of days to save the materialized view data before it is deleted.