unfiltered_table_metadatas

Creates, updates, deletes, gets or lists an unfiltered_table_metadatas resource.

Overview

Name	unfiltered_table_metadatas
Type	Resource
Id	aws.glue.unfiltered_table_metadatas

Fields

The following fields are returned by SELECT queries:

get_unfiltered_table_metadata

Name	Datatype	Description
authorized_columns	array	A list of column names that the user has been granted access to.
cell_filters	array	A list of column row filters.
is_materialized_view	boolean	Indicates if a table is a materialized view.
is_multi_dialect_view	boolean	Specifies whether the view supports the SQL dialects of one or more different query engines and can therefore be read by those engines.
is_protected	boolean	A flag that instructs the engine not to push user-provided operations into the logical plan of the view during query planning. However, if set this flag does not guarantee that the engine will comply. Refer to the engine's documentation to understand the guarantees provided, if any.
is_registered_with_lake_formation	boolean	A Boolean value that indicates whether the partition location is registered with Lake Formation.
permissions	array	The Lake Formation data permissions of the caller on the table. Used to authorize the call when no view context is found.
query_authorization_id	string	A cryptographically generated query identifier generated by Glue or Lake Formation. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*</code>)
resource_arn	string	The resource ARN of the parent resource extracted from the request.
row_filter	string	The filter that applies to the table. For example when applying the filter in SQL, it would go in the WHERE clause and can be evaluated by using an AND operator with any other predicates applied by the user querying the table. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\r\n\t]*</code>)
table	object	Represents a collection of related data organized in columns and rows.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_unfiltered_table_metadata	select	region		Allows a third-party analytical engine to retrieve unfiltered table metadata from the Data Catalog. For IAM authorization, the public IAM action associated with this API is glue:GetTable.

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_unfiltered_table_metadata

Allows a third-party analytical engine to retrieve unfiltered table metadata from the Data Catalog. For IAM authorization, the public IAM action associated with this API is glue:GetTable.

SELECT
authorized_columns,
cell_filters,
is_materialized_view,
is_multi_dialect_view,
is_protected,
is_registered_with_lake_formation,
permissions,
query_authorization_id,
resource_arn,
row_filter,
table
FROM aws.glue.unfiltered_table_metadatas
WHERE region = '{{ region }}' -- required
;