Materialized view API
The materialized view API describes the AWS Glue data types and operations for starting, stopping, and monitoring materialized view refresh task runs.
Data types
MaterializedViewRefreshTaskRun structure
The object that shows the details of the materialized view refresh task run.
Fields
-
CustomerId– UTF-8 string, not more than 12 bytes long.The AWS account ID.
-
MaterializedViewRefreshTaskRunId– UTF-8 string, matching the Custom string pattern #48.The identifier of the materialized view refresh task run.
-
DatabaseName– UTF-8 string.The database where the table resides.
-
TableName– UTF-8 string.The name of the materialized view.
-
CatalogId– Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The ID of the Data Catalog where the table resides. If none is supplied, the account ID is used by default.
-
Role– UTF-8 string.The IAM role that the service assumes to run the materialized view refresh task.
-
Status– UTF-8 string (valid values:STARTING|RUNNING|SUCCEEDED|FAILED|STOPPED).The status of the task run.
-
CreationTime– Timestamp.The time that this task was created.
-
LastUpdated– Timestamp.The last point in time when this task was modified.
-
StartTime– Timestamp.The start time of the task.
-
EndTime– Timestamp.The end time of the task.
-
ErrorMessage– Description string, not more than 2048 bytes long, matching the URI address multi-line string pattern.The error message for the job.
-
DPUSeconds– Number (double).The calculated DPU usage in seconds for all autoscaled workers.
-
RefreshType– UTF-8 string (valid values:FULL|INCREMENTAL).The type of the refresh task run. Either FULL or INCREMENTAL.
-
ProcessedBytes– Number (long).The number of bytes the refresh task run has scanned to refresh the materialized view.
Operations
StartMaterializedViewRefreshTaskRun action (Python: start_materialized_view_refresh_task_run)
StopMaterializedViewRefreshTaskRun action (Python: stop_materialized_view_refresh_task_run)
GetMaterializedViewRefreshTaskRun action (Python: get_materialized_view_refresh_task_run)
ListMaterializedViewRefreshTaskRuns action (Python: list_materialized_view_refresh_task_runs)
StartMaterializedViewRefreshTaskRun action (Python: start_materialized_view_refresh_task_run)
Starts a materialized view refresh task run for a specified materialized view.
Request
-
CatalogId– Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The ID of the Data Catalog where the table reside. If none is supplied, the account ID is used by default.
-
DatabaseName– Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The name of the database where the table resides.
-
TableName– Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The name of the materialized view to run the refresh task for.
-
FullRefresh– Boolean.Specifies whether this is a full refresh of the task run.
Response
-
MaterializedViewRefreshTaskRunId– UTF-8 string, matching the Custom string pattern #48.The identifier for the materialized view refresh task run.
Errors
AccessDeniedExceptionEntityNotFoundExceptionMaterializedViewRefreshTaskRunningExceptionOperationTimeoutExceptionResourceNumberLimitExceededExceptionInvalidInputException
StopMaterializedViewRefreshTaskRun action (Python: stop_materialized_view_refresh_task_run)
Stops a materialized view refresh task run for a specified materialized view.
Request
-
CatalogId– Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The ID of the Data Catalog where the table reside. If none is supplied, the account ID is used by default.
-
DatabaseName– Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The name of the database where the table resides.
-
TableName– Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The name of the materialized view.
Response
No Response parameters.
Errors
AccessDeniedExceptionMaterializedViewRefreshTaskNotRunningExceptionMaterializedViewRefreshTaskStoppingExceptionInvalidInputExceptionOperationTimeoutException
GetMaterializedViewRefreshTaskRun action (Python: get_materialized_view_refresh_task_run)
Get the associated metadata/information for a task run, given a task run ID.
Request
-
CatalogId– Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The ID of the Data Catalog where the table resides. If none is supplied, the account ID is used by default.
-
MaterializedViewRefreshTaskRunId– Required: UTF-8 string, matching the Custom string pattern #48.The identifier for the particular materialized view refresh task run.
Response
-
MaterializedViewRefreshTaskRun– A MaterializedViewRefreshTaskRun object.A MaterializedViewRefreshTaskRun object representing the details of the task run.
Errors
AccessDeniedExceptionEntityNotFoundExceptionOperationTimeoutExceptionInvalidInputException
ListMaterializedViewRefreshTaskRuns action (Python: list_materialized_view_refresh_task_runs)
List all task runs for a particular account.
Request
-
CatalogId– Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The ID of the Data Catalog where the table resides. If none is supplied, the account ID is used by default.
-
DatabaseName– UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The database where the table resides.
-
TableName– UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.The name of the materialized view.
-
MaxResults– Number (integer), not less than 1 or more than 1000.The maximum size of the response.
-
NextToken– UTF-8 string.A continuation token, if this is a continuation call.
Response
-
MaterializedViewRefreshTaskRuns– An array of MaterializedViewRefreshTaskRun objects.The results of the ListMaterializedViewRefreshTaskRuns action.
-
NextToken– UTF-8 string.A continuation token, if not all task run IDs have yet been returned.
Errors
AccessDeniedExceptionInvalidInputExceptionOperationTimeoutException
Exceptions
MaterializedViewRefreshTaskRunningException structure
Exception thrown when a task is already in running state.
Fields
-
Message– UTF-8 string.A message describing the problem.
MaterializedViewRefreshTaskNotRunningException structure
Exception thrown when stopping a task that is not in running state.
Fields
-
Message– UTF-8 string.A message describing the problem.
MaterializedViewRefreshTaskStoppingException structure
Exception thrown when a task is already in stopping state.
Fields
-
Message– UTF-8 string.A message describing the problem.