Retrieves a list of strings that identify available versions of a specified table¶
Description¶
Retrieves a list of strings that identify available versions of a specified table.
Usage¶
Arguments¶
-
CatalogIdThe ID of the Data Catalog where the tables reside. If none is provided, the Amazon Web Services account ID is used by default.
-
DatabaseName[required] The database in the catalog in which the table resides. For Hive compatibility, this name is entirely lowercase.
-
TableName[required] The name of the table. For Hive compatibility, this name is entirely lowercase.
-
NextTokenA continuation token, if this is not the first call.
-
MaxResultsThe maximum number of table versions to return in one response.
-
AuditContextA structure containing the Lake Formation audit context.
Value¶
A list with the following syntax:
list(
TableVersions = list(
list(
Table = list(
Name = "string",
DatabaseName = "string",
Description = "string",
Owner = "string",
CreateTime = as.POSIXct(
"2015-01-01"
),
UpdateTime = as.POSIXct(
"2015-01-01"
),
LastAccessTime = as.POSIXct(
"2015-01-01"
),
LastAnalyzedTime = as.POSIXct(
"2015-01-01"
),
Retention = 123,
StorageDescriptor = list(
Columns = list(
list(
Name = "string",
Type = "string",
Comment = "string",
Parameters = list(
"string"
)
)
),
Location = "string",
AdditionalLocations = list(
"string"
),
InputFormat = "string",
OutputFormat = "string",
Compressed = TRUE|FALSE,
NumberOfBuckets = 123,
SerdeInfo = list(
Name = "string",
SerializationLibrary = "string",
Parameters = list(
"string"
)
),
BucketColumns = list(
"string"
),
SortColumns = list(
list(
Column = "string",
SortOrder = 123
)
),
Parameters = list(
"string"
),
SkewedInfo = list(
SkewedColumnNames = list(
"string"
),
SkewedColumnValues = list(
"string"
),
SkewedColumnValueLocationMaps = list(
"string"
)
),
StoredAsSubDirectories = TRUE|FALSE,
SchemaReference = list(
SchemaId = list(
SchemaArn = "string",
SchemaName = "string",
RegistryName = "string"
),
SchemaVersionId = "string",
SchemaVersionNumber = 123
)
),
PartitionKeys = list(
list(
Name = "string",
Type = "string",
Comment = "string",
Parameters = list(
"string"
)
)
),
ViewOriginalText = "string",
ViewExpandedText = "string",
TableType = "string",
Parameters = list(
"string"
),
CreatedBy = "string",
IsRegisteredWithLakeFormation = TRUE|FALSE,
TargetTable = list(
CatalogId = "string",
DatabaseName = "string",
Name = "string",
Region = "string"
),
CatalogId = "string",
VersionId = "string",
FederatedTable = list(
Identifier = "string",
DatabaseIdentifier = "string",
ConnectionName = "string",
ConnectionType = "string"
),
ViewDefinition = list(
IsProtected = TRUE|FALSE,
IsManaged = TRUE|FALSE,
Definer = "string",
ViewVersionId = 123,
ViewVersionToken = "string",
RefreshSeconds = 123,
LastRefreshType = "FULL"|"INCREMENTAL",
SubObjects = list(
"string"
),
SubObjectVersionIds = list(
123
),
SubObjectsStatistics = list(
list(
SourceType = "HIVE_PARQUET"|"HIVE_ORC"|"HIVE_CSV"|"HIVE_JSON"|"PLAIN_PARQUET"|"ICEBERG",
GlueVersionId = "string",
PartitionCount = 123,
FileCount = 123,
TotalFileBytes = 123
)
),
Representations = list(
list(
Dialect = "REDSHIFT"|"ATHENA"|"SPARK",
DialectVersion = "string",
ViewOriginalText = "string",
ViewExpandedText = "string",
ValidationConnection = "string",
IsStale = TRUE|FALSE
)
),
SparkPipelineInfo = list(
"string"
)
),
IsMultiDialectView = TRUE|FALSE,
IsMaterializedView = TRUE|FALSE,
IcebergTableMetadata = list(
FormatVersion = "string",
TableUuid = "string",
Location = "string",
Properties = list(
"string"
),
Schemas = list(
list(
SchemaId = 123,
IdentifierFieldIds = list(
123
),
Type = "struct",
Fields = list(
list(
Id = 123,
Name = "string",
Type = list(),
Required = TRUE|FALSE,
Doc = "string",
InitialDefault = list(),
WriteDefault = list()
)
)
)
),
CurrentSchemaId = 123,
LastColumnId = 123,
PartitionSpecs = list(
list(
Fields = list(
list(
SourceId = 123,
Transform = "string",
Name = "string",
FieldId = 123
)
),
SpecId = 123
)
),
DefaultSpecId = 123,
LastPartitionId = 123,
SortOrders = list(
list(
OrderId = 123,
Fields = list(
list(
SourceId = 123,
Transform = "string",
Direction = "asc"|"desc",
NullOrder = "nulls-first"|"nulls-last"
)
)
)
),
DefaultSortOrderId = 123
),
Status = list(
RequestedBy = "string",
UpdatedBy = "string",
RequestTime = as.POSIXct(
"2015-01-01"
),
UpdateTime = as.POSIXct(
"2015-01-01"
),
Action = "UPDATE"|"CREATE",
State = "QUEUED"|"IN_PROGRESS"|"SUCCESS"|"STOPPED"|"FAILED",
Error = list(
ErrorCode = "string",
ErrorMessage = "string"
),
Details = list(
RequestedChange = list(),
ViewValidations = list(
list(
Dialect = "REDSHIFT"|"ATHENA"|"SPARK",
DialectVersion = "string",
ViewValidationText = "string",
UpdateTime = as.POSIXct(
"2015-01-01"
),
State = "QUEUED"|"IN_PROGRESS"|"SUCCESS"|"STOPPED"|"FAILED",
Error = list(
ErrorCode = "string",
ErrorMessage = "string"
)
)
)
)
)
),
VersionId = "string"
)
),
NextToken = "string"
)