column_statistics_for_partitions

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

Overview

Name	column_statistics_for_partitions
Type	Resource
Id	aws.glue.column_statistics_for_partitions

Fields

The following fields are returned by SELECT queries:

get_column_statistics_for_partition

Name	Datatype	Description
column_statistics_list	array	List of ColumnStatistics that failed to be retrieved.
errors	array	Error occurred during retrieving column statistics data.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_column_statistics_for_partition	select	region		Retrieves partition statistics of columns. The Identity and Access Management (IAM) permission required for this operation is GetPartition.
update_column_statistics_for_partition	update	region, DatabaseName, TableName, PartitionValues, ColumnStatisticsList		Creates or updates partition statistics of columns. The Identity and Access Management (IAM) permission required for this operation is UpdatePartition.
delete_column_statistics_for_partition	delete	region		Delete the partition column statistics of a column. The Identity and Access Management (IAM) permission required for this operation is DeletePartition.

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_column_statistics_for_partition

Retrieves partition statistics of columns. The Identity and Access Management (IAM) permission required for this operation is GetPartition.

SELECT
column_statistics_list,
errors
FROM aws.glue.column_statistics_for_partitions
WHERE region = '{{ region }}' -- required
;

UPDATE examples

update_column_statistics_for_partition

Creates or updates partition statistics of columns. The Identity and Access Management (IAM) permission required for this operation is UpdatePartition.

UPDATE aws.glue.column_statistics_for_partitions
SET 
CatalogId = '{{ CatalogId }}',
DatabaseName = '{{ DatabaseName }}',
TableName = '{{ TableName }}',
PartitionValues = '{{ PartitionValues }}',
ColumnStatisticsList = '{{ ColumnStatisticsList }}'
WHERE 
region = '{{ region }}' --required
AND DatabaseName = '{{ DatabaseName }}' --required
AND TableName = '{{ TableName }}' --required
AND PartitionValues = '{{ PartitionValues }}' --required
AND ColumnStatisticsList = '{{ ColumnStatisticsList }}' --required
RETURNING
errors;

DELETE examples

delete_column_statistics_for_partition

Delete the partition column statistics of a column. The Identity and Access Management (IAM) permission required for this operation is DeletePartition.

DELETE FROM aws.glue.column_statistics_for_partitions
WHERE region = '{{ region }}' --required
;