materialized_view_refresh_task_runs

Creates, updates, deletes, gets or lists a materialized_view_refresh_task_runs resource.

Overview

Name	materialized_view_refresh_task_runs
Type	Resource
Id	aws.glue.materialized_view_refresh_task_runs

Fields

The following fields are returned by SELECT queries:

get_materialized_view_refresh_task_run

Name	Datatype	Description
catalog_id	string	The ID of the Data Catalog where the table resides. If none is supplied, the account ID is used by default. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*</code>)
creation_time	string (date-time)	The time that this task was created.
customer_id	string	The Amazon Web Services account ID.
dpu_seconds	number (double)	The calculated DPU usage in seconds for all autoscaled workers.
database_name	string	The database where the table resides.
end_time	string (date-time)	The end time of the task.
error_message	string	The error message for the job. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\r\n\t]*</code>)
last_updated	string (date-time)	The last point in time when this task was modified.
materialized_view_refresh_task_run_id	string	The identifier of the materialized view refresh task run. (pattern: <code>[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}</code>)
processed_bytes	integer (int64)	The number of bytes the refresh task run has scanned to refresh the materialized view.
refresh_type	string	The type of the refresh task run. Either FULL or INCREMENTAL. (FULL, INCREMENTAL)
role	string	The IAM role that the service assumes to run the materialized view refresh task.
start_time	string (date-time)	The start time of the task.
status	string	The status of the task run. (STARTING, RUNNING, SUCCEEDED, FAILED, STOPPED)
table_name	string	The name of the materialized view.

list_materialized_view_refresh_task_runs

Name	Datatype	Description
catalog_id	string	The ID of the Data Catalog where the table resides. If none is supplied, the account ID is used by default. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*</code>)
creation_time	string (date-time)	The time that this task was created.
customer_id	string	The Amazon Web Services account ID.
dpu_seconds	number (double)	The calculated DPU usage in seconds for all autoscaled workers.
database_name	string	The database where the table resides.
end_time	string (date-time)	The end time of the task.
error_message	string	The error message for the job. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\r\n\t]*</code>)
last_updated	string (date-time)	The last point in time when this task was modified.
materialized_view_refresh_task_run_id	string	The identifier of the materialized view refresh task run. (pattern: <code>[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}</code>)
processed_bytes	integer (int64)	The number of bytes the refresh task run has scanned to refresh the materialized view.
refresh_type	string	The type of the refresh task run. Either FULL or INCREMENTAL. (FULL, INCREMENTAL)
role	string	The IAM role that the service assumes to run the materialized view refresh task.
start_time	string (date-time)	The start time of the task.
status	string	The status of the task run. (STARTING, RUNNING, SUCCEEDED, FAILED, STOPPED)
table_name	string	The name of the materialized view.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_materialized_view_refresh_task_run	select	region		Get the associated metadata/information for a task run, given a task run ID.
list_materialized_view_refresh_task_runs	select	region		List all task runs for a particular account.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

get_materialized_view_refresh_task_run

Get the associated metadata/information for a task run, given a task run ID.

SELECT
catalog_id,
creation_time,
customer_id,
dpu_seconds,
database_name,
end_time,
error_message,
last_updated,
materialized_view_refresh_task_run_id,
processed_bytes,
refresh_type,
role,
start_time,
status,
table_name
FROM aws.glue.materialized_view_refresh_task_runs
WHERE region = '{{ region }}' -- required
;

list_materialized_view_refresh_task_runs

List all task runs for a particular account.

SELECT
catalog_id,
creation_time,
customer_id,
dpu_seconds,
database_name,
end_time,
error_message,
last_updated,
materialized_view_refresh_task_run_id,
processed_bytes,
refresh_type,
role,
start_time,
status,
table_name
FROM aws.glue.materialized_view_refresh_task_runs
WHERE region = '{{ region }}' -- required
;