table_maintenance_job_status

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

Overview

Name	table_maintenance_job_status
Type	Resource
Id	aws.s3tables.table_maintenance_job_status

Fields

The following fields are returned by SELECT queries:

get_table_maintenance_job_status

Name	Datatype	Description
status	object	The status of the maintenance job.
table_arn	string	The Amazon Resource Name (ARN) of the table. (pattern: <code>(arn:aws[-a-z0-9]:[a-z0-9]+:[-a-z0-9]:[0-9]{12}:bucket/[a-z0-9_-]{3,63}/table/[a-zA-Z0-9-_]{1,255})</code>)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_table_maintenance_job_status	select	table_bucket_arn, namespace, name, region		Gets the status of a maintenance job for a table. For more information, see S3 Tables maintenance in the Amazon Simple Storage Service User Guide. Permissions You must have the s3tables:GetTableMaintenanceJobStatus permission to use this operation.

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
name	string	The name of the table containing the maintenance job status you want to check.
namespace	string	The name of the namespace the table is associated with.
region	string	AWS region (default: us-east-1)
table_bucket_arn	string	The Amazon Resource Name (ARN) of the table bucket.

SELECT examples

get_table_maintenance_job_status

Gets the status of a maintenance job for a table. For more information, see S3 Tables maintenance in the Amazon Simple Storage Service User Guide. Permissions You must have the s3tables:GetTableMaintenanceJobStatus permission to use this operation.

SELECT
status,
table_arn
FROM aws.s3tables.table_maintenance_job_status
WHERE table_bucket_arn = '{{ table_bucket_arn }}' -- required
AND namespace = '{{ namespace }}' -- required
AND name = '{{ name }}' -- required
AND region = '{{ region }}' -- required
;