Skip to content

Update Table

glue_update_table R Documentation

Updates a metadata table in the Data Catalog

Description

Updates a metadata table in the Data Catalog.

Usage

glue_update_table(CatalogId, DatabaseName, TableInput, SkipArchive,
  TransactionId, VersionId, ViewUpdateAction, Force)

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 catalog database in which the table resides. For Hive compatibility, this name is entirely lowercase.

TableInput

[required] An updated TableInput object to define the metadata table in the catalog.

SkipArchive

By default, update_table always creates an archived version of the table before updating it. However, if skipArchive is set to true, update_table does not create the archived version.

TransactionId

The transaction ID at which to update the table contents.

VersionId

The version ID at which to update the table contents.

ViewUpdateAction

The operation to be performed when updating the view.

Force

A flag that can be set to true to ignore matching storage descriptor and subobject matching requirements.

Value

An empty list.

Request syntax

svc$update_table(
  CatalogId = "string",
  DatabaseName = "string",
  TableInput = list(
    Name = "string",
    Description = "string",
    Owner = "string",
    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"
    ),
    TargetTable = list(
      CatalogId = "string",
      DatabaseName = "string",
      Name = "string",
      Region = "string"
    ),
    ViewDefinition = list(
      IsProtected = TRUE|FALSE,
      Definer = "string",
      Representations = list(
        list(
          Dialect = "REDSHIFT"|"ATHENA"|"SPARK",
          DialectVersion = "string",
          ViewOriginalText = "string",
          ValidationConnection = "string",
          ViewExpandedText = "string"
        )
      ),
      SubObjects = list(
        "string"
      )
    )
  ),
  SkipArchive = TRUE|FALSE,
  TransactionId = "string",
  VersionId = "string",
  ViewUpdateAction = "ADD"|"REPLACE"|"ADD_OR_REPLACE"|"DROP",
  Force = TRUE|FALSE
)