Skip to content

Get Table

glue_get_table R Documentation

Retrieves the Table definition in a Data Catalog for a specified table

Description

Retrieves the Table definition in a Data Catalog for a specified table.

Usage

glue_get_table(CatalogId, DatabaseName, Name, TransactionId,
  QueryAsOfTime, IncludeStatusDetails)

Arguments

CatalogId

The ID of the Data Catalog where the table resides. If none is provided, the Amazon Web Services account ID is used by default.

DatabaseName

[required] The name of the database in the catalog in which the table resides. For Hive compatibility, this name is entirely lowercase.

Name

[required] The name of the table for which to retrieve the definition. For Hive compatibility, this name is entirely lowercase.

TransactionId

The transaction ID at which to read the table contents.

QueryAsOfTime

The time as of when to read the table contents. If not set, the most recent transaction commit time will be used. Cannot be specified along with TransactionId.

IncludeStatusDetails

Specifies whether to include status details related to a request to create or update an Glue Data Catalog view.

Value

A list with the following syntax:

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"
            )
          )
        )
      )
    )
  )
)

Request syntax

svc$get_table(
  CatalogId = "string",
  DatabaseName = "string",
  Name = "string",
  TransactionId = "string",
  QueryAsOfTime = as.POSIXct(
    "2015-01-01"
  ),
  IncludeStatusDetails = TRUE|FALSE
)