REST Resource: projects.locations.catalogs.databases.tables

Resource: Table

Represents a table.

JSON representation
{
  "name": string,
  "createTime": string,
  "updateTime": string,
  "deleteTime": string,
  "expireTime": string,
  "type": enum (Type),
  "etag": string,

  // Union field options can be only one of the following:
  "hiveOptions": {
    object (HiveTableOptions)
  }
  // End of list of possible types for union field options.
}
Fields
name

string

Output only. The resource name. Format: projects/{project_id_or_number}/locations/{locationId}/catalogs/{catalogId}/databases/{databaseId}/tables/{tableId}

createTime

string (Timestamp format)

Output only. The creation time of the table.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

updateTime

string (Timestamp format)

Output only. The last modification time of the table.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

deleteTime

string (Timestamp format)

Output only. The deletion time of the table. Only set after the table is deleted.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

expireTime

string (Timestamp format)

Output only. The time when this table is considered expired. Only set after the table is deleted.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

type

enum (Type)

The table type.

etag

string

The checksum of a table object computed by the server based on the value of other fields. It may be sent on update requests to ensure the client has an up-to-date value before proceeding. It is only checked for update table operations.

Union field options. Options specified for the table type. options can be only one of the following:
hiveOptions

object (HiveTableOptions)

Options of a Hive table.

HiveTableOptions

Options of a Hive table.

JSON representation
{
  "parameters": {
    string: string,
    ...
  },
  "tableType": string,
  "storageDescriptor": {
    object (StorageDescriptor)
  }
}
Fields
parameters

map (key: string, value: string)

Stores user supplied Hive table parameters.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.

tableType

string

Hive table type. For example, MANAGED_TABLE, EXTERNAL_TABLE.

storageDescriptor

object (StorageDescriptor)

Stores physical storage information of the data.

StorageDescriptor

Stores physical storage information of the data.

JSON representation
{
  "locationUri": string,
  "inputFormat": string,
  "outputFormat": string,
  "serdeInfo": {
    object (SerDeInfo)
  }
}
Fields
locationUri

string

Cloud Storage folder URI where the table data is stored, starting with "gs://".

inputFormat

string

The fully qualified Java class name of the input format.

outputFormat

string

The fully qualified Java class name of the output format.

serdeInfo

object (SerDeInfo)

Serializer and deserializer information.

SerDeInfo

Serializer and deserializer information.

JSON representation
{
  "serializationLib": string
}
Fields
serializationLib

string

The fully qualified Java class name of the serialization library.

Type

The table type.

Enums
TYPE_UNSPECIFIED The type is not specified.
HIVE Represents a table compatible with Hive Metastore tables.

Methods

create

Creates a new table.

delete

Deletes an existing table specified by the table ID.

get

Gets the table specified by the resource name.

list

List all tables in a specified database.

patch

Updates an existing table specified by the table ID.

rename

Renames an existing table specified by the table ID.