Links

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.
Last modified 6mo ago