Skip to content

Get Table Optimizer

glue_get_table_optimizer R Documentation

Returns the configuration of all optimizers associated with a specified table

Description

Returns the configuration of all optimizers associated with a specified table.

Usage

glue_get_table_optimizer(CatalogId, DatabaseName, TableName, Type)

Arguments

CatalogId

[required] The Catalog ID of the table.

DatabaseName

[required] The name of the database in the catalog in which the table resides.

TableName

[required] The name of the table.

Type

[required] The type of table optimizer.

Value

A list with the following syntax:

list(
  CatalogId = "string",
  DatabaseName = "string",
  TableName = "string",
  TableOptimizer = list(
    type = "compaction"|"retention"|"orphan_file_deletion",
    configuration = list(
      roleArn = "string",
      enabled = TRUE|FALSE,
      vpcConfiguration = list(
        glueConnectionName = "string"
      ),
      retentionConfiguration = list(
        icebergConfiguration = list(
          snapshotRetentionPeriodInDays = 123,
          numberOfSnapshotsToRetain = 123,
          cleanExpiredFiles = TRUE|FALSE
        )
      ),
      orphanFileDeletionConfiguration = list(
        icebergConfiguration = list(
          orphanFileRetentionPeriodInDays = 123,
          location = "string"
        )
      )
    ),
    lastRun = list(
      eventType = "starting"|"completed"|"failed"|"in_progress",
      startTimestamp = as.POSIXct(
        "2015-01-01"
      ),
      endTimestamp = as.POSIXct(
        "2015-01-01"
      ),
      metrics = list(
        NumberOfBytesCompacted = "string",
        NumberOfFilesCompacted = "string",
        NumberOfDpus = "string",
        JobDurationInHour = "string"
      ),
      error = "string",
      compactionMetrics = list(
        IcebergMetrics = list(
          NumberOfBytesCompacted = 123,
          NumberOfFilesCompacted = 123,
          NumberOfDpus = 123,
          JobDurationInHour = 123.0
        )
      ),
      retentionMetrics = list(
        IcebergMetrics = list(
          NumberOfDataFilesDeleted = 123,
          NumberOfManifestFilesDeleted = 123,
          NumberOfManifestListsDeleted = 123,
          NumberOfDpus = 123,
          JobDurationInHour = 123.0
        )
      ),
      orphanFileDeletionMetrics = list(
        IcebergMetrics = list(
          NumberOfOrphanFilesDeleted = 123,
          NumberOfDpus = 123,
          JobDurationInHour = 123.0
        )
      )
    )
  )
)

Request syntax

svc$get_table_optimizer(
  CatalogId = "string",
  DatabaseName = "string",
  TableName = "string",
  Type = "compaction"|"retention"|"orphan_file_deletion"
)