Skip to content

Get Table Version

glue_get_table_version R Documentation

Retrieves a specified version of a table

Description

Retrieves a specified version of a table.

Usage

glue_get_table_version(CatalogId, DatabaseName, TableName, VersionId)

Arguments

CatalogId

The 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.

VersionId

The ID value of the table version to be retrieved. A VersionID is a string representation of an integer. Each version is incremented by 1.

Value

A list with the following syntax:

list(
  TableVersion = 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"
      ),
      ViewDefinition = list(
        IsProtected = TRUE|FALSE,
        Definer = "string",
        SubObjects = list(
          "string"
        ),
        Representations = list(
          list(
            Dialect = "REDSHIFT"|"ATHENA"|"SPARK",
            DialectVersion = "string",
            ViewOriginalText = "string",
            ViewExpandedText = "string",
            ValidationConnection = "string",
            IsStale = TRUE|FALSE
          )
        )
      ),
      IsMultiDialectView = TRUE|FALSE,
      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"
  )
)

Request syntax

svc$get_table_version(
  CatalogId = "string",
  DatabaseName = "string",
  TableName = "string",
  VersionId = "string"
)