Skip to content

/AWS1/CL_GLUVIEWDEFNINPUT

A structure containing details for creating or updating an Glue view.

CONSTRUCTOR

IMPORTING

Optional arguments:

iv_isprotected TYPE /AWS1/GLUNULLABLEBOOLEAN /AWS1/GLUNULLABLEBOOLEAN

You can set this flag as true to instruct the engine not to push user-provided operations into the logical plan of the view during query planning. However, setting this flag does not guarantee that the engine will comply. Refer to the engine's documentation to understand the guarantees provided, if any.

iv_definer TYPE /AWS1/GLUARNSTRING /AWS1/GLUARNSTRING

The definer of a view in SQL.

it_representations TYPE /AWS1/CL_GLUVIEWREPRESENTATI00=>TT_VIEWREPRESENTATIONINPUTLIST TT_VIEWREPRESENTATIONINPUTLIST

A list of structures that contains the dialect of the view, and the query that defines the view.

iv_viewversionid TYPE /AWS1/GLUTABLEVERSIONID /AWS1/GLUTABLEVERSIONID

The ID value that identifies this view's version. For materialized views, the version ID is the Apache Iceberg table's snapshot ID.

iv_viewversiontoken TYPE /AWS1/GLUVERSIONSTRING /AWS1/GLUVERSIONSTRING

The version ID of the Apache Iceberg table.

iv_refreshseconds TYPE /AWS1/GLUREFRESHSECONDS /AWS1/GLUREFRESHSECONDS

Auto refresh interval in seconds for the materialized view. If not specified, the view will not automatically refresh.

iv_lastrefreshtype TYPE /AWS1/GLULASTREFRESHTYPE /AWS1/GLULASTREFRESHTYPE

The type of the materialized view's last refresh. Valid values: Full, Incremental.

it_subobjects TYPE /AWS1/CL_GLUVIEWSUBOBJSLIST_W=>TT_VIEWSUBOBJECTSLIST TT_VIEWSUBOBJECTSLIST

A list of base table ARNs that make up the view.

it_subobjectversionids TYPE /AWS1/CL_GLUVIEWSUBOBJVRSIDS00=>TT_VIEWSUBOBJECTVERSIONIDSLIST TT_VIEWSUBOBJECTVERSIONIDSLIST

List of the Apache Iceberg table versions referenced by the materialized view.


Queryable Attributes

IsProtected

You can set this flag as true to instruct the engine not to push user-provided operations into the logical plan of the view during query planning. However, setting this flag does not guarantee that the engine will comply. Refer to the engine's documentation to understand the guarantees provided, if any.

Accessible with the following methods

Method Description
GET_ISPROTECTED() Getter for ISPROTECTED, with configurable default
ASK_ISPROTECTED() Getter for ISPROTECTED w/ exceptions if field has no value
HAS_ISPROTECTED() Determine if ISPROTECTED has a value

Definer

The definer of a view in SQL.

Accessible with the following methods

Method Description
GET_DEFINER() Getter for DEFINER, with configurable default
ASK_DEFINER() Getter for DEFINER w/ exceptions if field has no value
HAS_DEFINER() Determine if DEFINER has a value

Representations

A list of structures that contains the dialect of the view, and the query that defines the view.

Accessible with the following methods

Method Description
GET_REPRESENTATIONS() Getter for REPRESENTATIONS, with configurable default
ASK_REPRESENTATIONS() Getter for REPRESENTATIONS w/ exceptions if field has no val
HAS_REPRESENTATIONS() Determine if REPRESENTATIONS has a value

ViewVersionId

The ID value that identifies this view's version. For materialized views, the version ID is the Apache Iceberg table's snapshot ID.

Accessible with the following methods

Method Description
GET_VIEWVERSIONID() Getter for VIEWVERSIONID

ViewVersionToken

The version ID of the Apache Iceberg table.

Accessible with the following methods

Method Description
GET_VIEWVERSIONTOKEN() Getter for VIEWVERSIONTOKEN, with configurable default
ASK_VIEWVERSIONTOKEN() Getter for VIEWVERSIONTOKEN w/ exceptions if field has no va
HAS_VIEWVERSIONTOKEN() Determine if VIEWVERSIONTOKEN has a value

RefreshSeconds

Auto refresh interval in seconds for the materialized view. If not specified, the view will not automatically refresh.

Accessible with the following methods

Method Description
GET_REFRESHSECONDS() Getter for REFRESHSECONDS, with configurable default
ASK_REFRESHSECONDS() Getter for REFRESHSECONDS w/ exceptions if field has no valu
HAS_REFRESHSECONDS() Determine if REFRESHSECONDS has a value

LastRefreshType

The type of the materialized view's last refresh. Valid values: Full, Incremental.

Accessible with the following methods

Method Description
GET_LASTREFRESHTYPE() Getter for LASTREFRESHTYPE, with configurable default
ASK_LASTREFRESHTYPE() Getter for LASTREFRESHTYPE w/ exceptions if field has no val
HAS_LASTREFRESHTYPE() Determine if LASTREFRESHTYPE has a value

SubObjects

A list of base table ARNs that make up the view.

Accessible with the following methods

Method Description
GET_SUBOBJECTS() Getter for SUBOBJECTS, with configurable default
ASK_SUBOBJECTS() Getter for SUBOBJECTS w/ exceptions if field has no value
HAS_SUBOBJECTS() Determine if SUBOBJECTS has a value

SubObjectVersionIds

List of the Apache Iceberg table versions referenced by the materialized view.

Accessible with the following methods

Method Description
GET_SUBOBJECTVERSIONIDS() Getter for SUBOBJECTVERSIONIDS, with configurable default
ASK_SUBOBJECTVERSIONIDS() Getter for SUBOBJECTVERSIONIDS w/ exceptions if field has no
HAS_SUBOBJECTVERSIONIDS() Determine if SUBOBJECTVERSIONIDS has a value