table_metadatas
Creates, updates, deletes, gets or lists a table_metadatas resource.
Overview
| Name | table_metadatas |
| Type | Resource |
| Id | aws.athena.table_metadatas |
Fields
The following fields are returned by SELECT queries:
- get_table_metadata
- list_table_metadata
| Name | Datatype | Description |
|---|---|---|
columns | array | A list of the columns in the table. |
create_time | string (date-time) | The time that the table was created. |
last_access_time | string (date-time) | The last time the table was accessed. |
name | string | The name of the table. |
parameters | object | A set of custom key/value pairs for table properties. |
partition_keys | array | A list of the partition keys in the table. |
table_type | string | The type of table. In Athena, only EXTERNAL_TABLE is supported. |
| Name | Datatype | Description |
|---|---|---|
columns | array | A list of the columns in the table. |
create_time | string (date-time) | The time that the table was created. |
last_access_time | string (date-time) | The last time the table was accessed. |
name | string | The name of the table. |
parameters | object | A set of custom key/value pairs for table properties. |
partition_keys | array | A list of the partition keys in the table. |
table_type | string | The type of table. In Athena, only EXTERNAL_TABLE is supported. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get_table_metadata | select | region | Returns table metadata for the specified catalog, database, and table. | |
list_table_metadata | select | region | Lists the metadata for the tables in the specified data catalog database. |
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_metadata
- list_table_metadata
Returns table metadata for the specified catalog, database, and table.
SELECT
columns,
create_time,
last_access_time,
name,
parameters,
partition_keys,
table_type
FROM aws.athena.table_metadatas
WHERE region = '{{ region }}' -- required
;
Lists the metadata for the tables in the specified data catalog database.
SELECT
columns,
create_time,
last_access_time,
name,
parameters,
partition_keys,
table_type
FROM aws.athena.table_metadatas
WHERE region = '{{ region }}' -- required
;