column_statistics_for_tables

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

Overview

Name	column_statistics_for_tables
Type	Resource
Id	aws.glue.column_statistics_for_tables

Fields

The following fields are returned by SELECT queries:

get_column_statistics_for_table

Name	Datatype	Description
column_statistics_list	array	List of ColumnStatistics.
errors	array	List of ColumnStatistics that failed to be retrieved.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_column_statistics_for_table	select	region		Retrieves table statistics of columns. The Identity and Access Management (IAM) permission required for this operation is GetTable.
update_column_statistics_for_table	update	region, DatabaseName, TableName, ColumnStatisticsList		Creates or updates table statistics of columns. The Identity and Access Management (IAM) permission required for this operation is UpdateTable.
delete_column_statistics_for_table	delete	region		Retrieves table statistics of columns. The Identity and Access Management (IAM) permission required for this operation is DeleteTable.

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_table

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

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

UPDATE examples

update_column_statistics_for_table

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

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

DELETE examples

delete_column_statistics_for_table

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

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