table_objects

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

Overview

Name	table_objects
Type	Resource
Id	aws.lakeformation.table_objects

Fields

The following fields are returned by SELECT queries:

get_table_objects

Name	Datatype	Description
next_token	string	A continuation token indicating whether additional data is available.
objects	array	A list of objects organized by partition keys.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_table_objects	select	region		Returns the set of Amazon S3 objects that make up the specified governed table. A transaction ID or timestamp can be specified for time-travel queries.
update_table_objects	update	region, DatabaseName, TableName, WriteOperations		Updates the manifest of Amazon S3 objects that make up the specified governed table.

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_table_objects

Returns the set of Amazon S3 objects that make up the specified governed table. A transaction ID or timestamp can be specified for time-travel queries.

SELECT
next_token,
objects
FROM aws.lakeformation.table_objects
WHERE region = '{{ region }}' -- required
;

UPDATE examples

update_table_objects

Updates the manifest of Amazon S3 objects that make up the specified governed table.

UPDATE aws.lakeformation.table_objects
SET 
CatalogId = '{{ CatalogId }}',
DatabaseName = '{{ DatabaseName }}',
TableName = '{{ TableName }}',
TransactionId = '{{ TransactionId }}',
WriteOperations = '{{ WriteOperations }}'
WHERE 
region = '{{ region }}' --required
AND DatabaseName = '{{ DatabaseName }}' --required
AND TableName = '{{ TableName }}' --required
AND WriteOperations = '{{ WriteOperations }}' --required;