Table API

• Table structure

• TableInput structure

• Column structure

• StorageDescriptor structure

• SchemaReference structure

• SerDeInfo structure

• Order structure

• SkewedInfo structure

• TableVersion structure

• TableError structure

• TableVersionError structure

• SortCriterion structure

• TableIdentifier structure

• KeySchemaElement structure

• PartitionIndex structure

• PartitionIndexDescriptor structure

• BackfillError structure

Fields

• Name – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The table name. For Hive compatibility, this must be entirely lowercase.

• DatabaseName – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the database where the table metadata resides. For Hive compatibility, this must be all lowercase.

• Description – Description string, not more than 2048 bytes long, matching the URI address multi-line string pattern.

  A description of the table.

• Owner – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The owner of the table.

• CreateTime – Timestamp.

  The time when the table definition was created in the Data Catalog.

• UpdateTime – Timestamp.

  The last time that the table was updated.

• LastAccessTime – Timestamp.

  The last time that the table was accessed. This is usually taken from HDFS, and might not be reliable.

• LastAnalyzedTime – Timestamp.

  The last time that column statistics were computed for this table.

• Retention – Number (integer), not more than None.

  The retention time for this table.

• StorageDescriptor – A StorageDescriptor object.

  A storage descriptor containing information about the physical storage of this table.

• PartitionKeys – An array of Column objects.

  A list of columns by which the table is partitioned. Only primitive types are supported as partition keys.

  When you create a table used by Amazon Athena, and you do not specify any partitionKeys, you must at least set the value of partitionKeys to an empty list. For example:

  "PartitionKeys": []

• ViewOriginalText – UTF-8 string, not more than 409600 bytes long.

  If the table is a view, the original text of the view; otherwise null.

• ViewExpandedText – UTF-8 string, not more than 409600 bytes long.

  If the table is a view, the expanded text of the view; otherwise null.

• TableType – UTF-8 string, not more than 255 bytes long.

  The type of this table (EXTERNAL_TABLE, VIRTUAL_VIEW, etc.).

• Parameters – A map array of key-value pairs.

  Each key is a Key string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Each value is a UTF-8 string, not more than 512000 bytes long.

  These key-value pairs define properties associated with the table.

• CreatedBy – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The person or entity who created the table.

• IsRegisteredWithLakeFormation – Boolean.

  Indicates whether the table has been registered with Amazon Lake Formation.

• TargetTable – A TableIdentifier object.

  A TableIdentifier structure that describes a target table for resource linking.

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog in which the table resides.

• VersionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the table version.

Fields

• Name – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The table name. For Hive compatibility, this is folded to lowercase when it is stored.

• Description – Description string, not more than 2048 bytes long, matching the URI address multi-line string pattern.

  A description of the table.

• Owner – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The table owner.

• LastAccessTime – Timestamp.

  The last time that the table was accessed.

• LastAnalyzedTime – Timestamp.

  The last time that column statistics were computed for this table.

• Retention – Number (integer), not more than None.

  The retention time for this table.

• StorageDescriptor – A StorageDescriptor object.

  A storage descriptor containing information about the physical storage of this table.

• PartitionKeys – An array of Column objects.

  A list of columns by which the table is partitioned. Only primitive types are supported as partition keys.

  When you create a table used by Amazon Athena, and you do not specify any partitionKeys, you must at least set the value of partitionKeys to an empty list. For example:

  "PartitionKeys": []

• ViewOriginalText – UTF-8 string, not more than 409600 bytes long.

  If the table is a view, the original text of the view; otherwise null.

• ViewExpandedText – UTF-8 string, not more than 409600 bytes long.

  If the table is a view, the expanded text of the view; otherwise null.

• TableType – UTF-8 string, not more than 255 bytes long.

  The type of this table (EXTERNAL_TABLE, VIRTUAL_VIEW, etc.).

• Parameters – A map array of key-value pairs.

  Each key is a Key string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Each value is a UTF-8 string, not more than 512000 bytes long.

  These key-value pairs define properties associated with the table.

• TargetTable – A TableIdentifier object.

  A TableIdentifier structure that describes a target table for resource linking.

Fields

• Name – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the Column.

• Type – UTF-8 string, not more than 131072 bytes long, matching the Single-line string pattern.

  The data type of the Column.

• Comment – Comment string, not more than 255 bytes long, matching the Single-line string pattern.

  A free-form text comment.

• Parameters – A map array of key-value pairs.

  Each key is a Key string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Each value is a UTF-8 string, not more than 512000 bytes long.

  These key-value pairs define properties associated with the column.

Fields

• Columns – An array of Column objects.

  A list of the Columns in the table.

• Location – Location string, not more than 2056 bytes long, matching the URI address multi-line string pattern.

  The physical location of the table. By default, this takes the form of the warehouse location, followed by the database location in the warehouse, followed by the table name.

• AdditionalLocations – An array of UTF-8 strings.

  A list of locations that point to the path where a Delta table is located.

• InputFormat – Format string, not more than 128 bytes long, matching the Single-line string pattern.

  The input format: SequenceFileInputFormat (binary), or TextInputFormat, or a custom format.

• OutputFormat – Format string, not more than 128 bytes long, matching the Single-line string pattern.

  The output format: SequenceFileOutputFormat (binary), or IgnoreKeyTextOutputFormat, or a custom format.

• Compressed – Boolean.

  True if the data in the table is compressed, or False if not.

• NumberOfBuckets – Number (integer).

  Must be specified if the table contains any dimension columns.

• SerdeInfo – A SerDeInfo object.

  The serialization/deserialization (SerDe) information.

• BucketColumns – An array of UTF-8 strings.

  A list of reducer grouping columns, clustering columns, and bucketing columns in the table.

• SortColumns – An array of Order objects.

  A list specifying the sort order of each bucket in the table.

• Parameters – A map array of key-value pairs.

  Each key is a Key string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Each value is a UTF-8 string, not more than 512000 bytes long.

  The user-supplied properties in key-value form.

• SkewedInfo – A SkewedInfo object.

  The information about values that appear frequently in a column (skewed values).

• StoredAsSubDirectories – Boolean.

  True if the table data is stored in subdirectories, or False if not.

• SchemaReference – A SchemaReference object.

  An object that references a schema stored in the Amazon Glue Schema Registry.

  When creating a table, you can pass an empty list of columns for the schema, and instead use a schema reference.

Fields

• SchemaId – A SchemaId object.

  A structure that contains schema identity fields. Either this or the SchemaVersionId has to be provided.

• SchemaVersionId – UTF-8 string, not less than 36 or more than 36 bytes long, matching the Custom string pattern #12.

  The unique ID assigned to a version of the schema. Either this or the SchemaId has to be provided.

• SchemaVersionNumber – Number (long), not less than 1 or more than 100000.

  The version number of the schema.

Fields

• Name – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Name of the SerDe.

• SerializationLibrary – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Usually the class that implements the SerDe. An example is org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe.

• Parameters – A map array of key-value pairs.

  Each key is a Key string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Each value is a UTF-8 string, not more than 512000 bytes long.

  These key-value pairs define initialization parameters for the SerDe.

Fields

• Column – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the column.

• SortOrder – Required: Number (integer), not more than 1.

  Indicates that the column is sorted in ascending order (== 1), or in descending order (==0).

Fields

• SkewedColumnNames – An array of UTF-8 strings.

  A list of names of columns that contain skewed values.

• SkewedColumnValues – An array of UTF-8 strings.

  A list of values that appear so frequently as to be considered skewed.

• SkewedColumnValueLocationMaps – A map array of key-value pairs.

  Each key is a UTF-8 string.

  Each value is a UTF-8 string.

  A mapping of skewed values to the columns that contain them.

Fields

• Table – A Table object.

  The table in question.

• VersionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID value that identifies this table version. A VersionId is a string representation of an integer. Each version is incremented by 1.

Fields

• TableName – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the table. For Hive compatibility, this must be entirely lowercase.

• ErrorDetail – An ErrorDetail object.

  The details about the error.

Fields

• TableName – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the table in question.

• VersionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID value of the version in question. A VersionID is a string representation of an integer. Each version is incremented by 1.

• ErrorDetail – An ErrorDetail object.

  The details about the error.

Fields

• FieldName – Value string, not more than 1024 bytes long.

  The name of the field on which to sort.

• Sort – UTF-8 string (valid values: ASC="ASCENDING" | DESC="DESCENDING").

  An ascending or descending sort.

Fields

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog in which the table resides.

• DatabaseName – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the catalog database that contains the target table.

• Name – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the target table.

Fields

• Name – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of a partition key.

• Type – Required: UTF-8 string, not more than 131072 bytes long, matching the Single-line string pattern.

  The type of a partition key.

Fields

• Keys – Required: An array of UTF-8 strings, at least 1 string.

  The keys for the partition index.

• IndexName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the partition index.

Fields

• IndexName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the partition index.

• Keys – Required: An array of KeySchemaElement objects, at least 1 structure.

  A list of one or more keys, as KeySchemaElement structures, for the partition index.

• IndexStatus – Required: UTF-8 string (valid values: CREATING | ACTIVE | DELETING | FAILED).

  The status of the partition index.

  The possible statuses are:

  • CREATING: The index is being created. When an index is in a CREATING state, the index or its table cannot be deleted.

  • ACTIVE: The index creation succeeds.

  • FAILED: The index creation fails.

  • DELETING: The index is deleted from the list of indexes.

• BackfillErrors – An array of BackfillError objects.

  A list of errors that can occur when registering partition indexes for an existing table.

• EncryptedPartitionError: The partitions are encrypted.

• InvalidPartitionTypeDataError: The partition value doesn't match the data type for that partition column.

• MissingPartitionValueError: The partitions are encrypted.

• UnsupportedPartitionCharacterError: Characters inside the partition value are not supported. For example: U+0000 , U+0001, U+0002.

• InternalError: Any error which does not belong to other error codes.

Fields

• Code – UTF-8 string (valid values: ENCRYPTED_PARTITION_ERROR | INTERNAL_ERROR | INVALID_PARTITION_TYPE_DATA_ERROR | MISSING_PARTITION_VALUE_ERROR | UNSUPPORTED_PARTITION_CHARACTER_ERROR).

  The error code for an error that occurred when registering partition indexes for an existing table.

• Partitions – An array of PartitionValueList objects.

  A list of a limited number of partitions in the response.

• CreateTable action (Python: create_table)

• UpdateTable action (Python: update_table)

• DeleteTable action (Python: delete_table)

• BatchDeleteTable action (Python: batch_delete_table)

• GetTable action (Python: get_table)

• GetTables action (Python: get_tables)

• GetTableVersion action (Python: get_table_version)

• GetTableVersions action (Python: get_table_versions)

• DeleteTableVersion action (Python: delete_table_version)

• BatchDeleteTableVersion action (Python: batch_delete_table_version)

• SearchTables action (Python: search_tables)

• GetPartitionIndexes action (Python: get_partition_indexes)

• CreatePartitionIndex action (Python: create_partition_index)

• DeletePartitionIndex action (Python: delete_partition_index)

• GetColumnStatisticsForTable action (Python: get_column_statistics_for_table)

• UpdateColumnStatisticsForTable action (Python: update_column_statistics_for_table)

• DeleteColumnStatisticsForTable action (Python: delete_column_statistics_for_table)

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog in which to create the Table. If none is supplied, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The catalog database in which to create the new table. For Hive compatibility, this name is entirely lowercase.

• TableInput – Required: A TableInput object.

  The TableInput object that defines the metadata table to create in the catalog.

• PartitionIndexes – An array of PartitionIndex objects, not more than 3 structures.

  A list of partition indexes, PartitionIndex structures, to create in the table.

• TransactionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Custom string pattern #11.

  The ID of the transaction.

Response

• No Response parameters.

Errors

• AlreadyExistsException

• InvalidInputException

• EntityNotFoundException

• ResourceNumberLimitExceededException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException

• ConcurrentModificationException

• ResourceNotReadyException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• TableInput – Required: A TableInput object.

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

• SkipArchive – Boolean.

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

• TransactionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Custom string pattern #11.

  The transaction ID at which to update the table contents.

• VersionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The version ID at which to update the table contents.

Response

• No Response parameters.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

• ConcurrentModificationException

• ResourceNumberLimitExceededException

• GlueEncryptionException

• ResourceNotReadyException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• Name – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the table to be deleted. For Hive compatibility, this name is entirely lowercase.

• TransactionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Custom string pattern #11.

  The transaction ID at which to delete the table contents.

Response

• No Response parameters.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

• ConcurrentModificationException

• ResourceNotReadyException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the catalog database in which the tables to delete reside. For Hive compatibility, this name is entirely lowercase.

• TablesToDelete – Required: An array of UTF-8 strings, not more than 100 strings.

  A list of the table to delete.

• TransactionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Custom string pattern #11.

  The transaction ID at which to delete the table contents.

Response

• Errors – An array of TableError objects.

  A list of errors encountered in attempting to delete the specified tables.

Errors

• InvalidInputException

• EntityNotFoundException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException

• ResourceNotReadyException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• Name – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• TransactionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Custom string pattern #11.

  The transaction ID at which to read the table contents.

• QueryAsOfTime – Timestamp.

  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.

Response

• Table – A Table object.

  The Table object that defines the specified table.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException

• ResourceNotReadyException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog where the tables reside. If none is provided, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The database in the catalog whose tables to list. For Hive compatibility, this name is entirely lowercase.

• Expression – UTF-8 string, not more than 2048 bytes long, matching the Single-line string pattern.

  A regular expression pattern. If present, only those tables whose names match the pattern are returned.

• NextToken – UTF-8 string.

  A continuation token, included if this is a continuation call.

• MaxResults – Number (integer), not less than 1 or more than 100.

  The maximum number of tables to return in a single response.

• TransactionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Custom string pattern #11.

  The transaction ID at which to read the table contents.

• QueryAsOfTime – Timestamp.

  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.

Response

• TableList – An array of Table objects.

  A list of the requested Table objects.

• NextToken – UTF-8 string.

  A continuation token, present if the current list segment is not the last.

Errors

• EntityNotFoundException

• InvalidInputException

• OperationTimeoutException

• InternalServiceException

• GlueEncryptionException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog where the tables reside. If none is provided, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the table. For Hive compatibility, this name is entirely lowercase.

• VersionId – UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  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.

Response

• TableVersion – A TableVersion object.

  The requested table version.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog where the tables reside. If none is provided, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the table. For Hive compatibility, this name is entirely lowercase.

• NextToken – UTF-8 string.

  A continuation token, if this is not the first call.

• MaxResults – Number (integer), not less than 1 or more than 100.

  The maximum number of table versions to return in one response.

Response

• TableVersions – An array of TableVersion objects.

  A list of strings identifying available versions of the specified table.

• NextToken – UTF-8 string.

  A continuation token, if the list of available versions does not include the last one.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog where the tables reside. If none is provided, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the table. For Hive compatibility, this name is entirely lowercase.

• VersionId – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

Response

• No Response parameters.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog where the tables reside. If none is provided, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

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

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the table. For Hive compatibility, this name is entirely lowercase.

• VersionIds – Required: An array of UTF-8 strings, not more than 100 strings.

  A list of the IDs of versions to be deleted. A VersionId is a string representation of an integer. Each version is incremented by 1.

Response

• Errors – An array of TableVersionError objects.

  A list of errors encountered while trying to delete the specified table versions.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  A unique identifier, consisting of account_id.

• NextToken – UTF-8 string.

  A continuation token, included if this is a continuation call.

• Filters – An array of PropertyPredicate objects.

  A list of key-value pairs, and a comparator used to filter the search results. Returns all entities matching the predicate.

  The Comparator member of the PropertyPredicate struct is used only for time fields, and can be omitted for other field types. Also, when comparing string values, such as when Key=Name, a fuzzy match algorithm is used. The Key field (for example, the value of the Name field) is split on certain punctuation characters, for example, -, :, #, etc. into tokens. Then each token is exact-match compared with the Value member of PropertyPredicate. For example, if Key=Name and Value=link, tables named customer-link and xx-link-yy are returned, but xxlinkyy is not returned.

• SearchText – Value string, not more than 1024 bytes long.

  A string used for a text search.

  Specifying a value in quotes filters based on an exact match to the value.

• SortCriteria – An array of SortCriterion objects, not more than 1 structures.

  A list of criteria for sorting the results by a field name, in an ascending or descending order.

• MaxResults – Number (integer), not less than 1 or more than 1000.

  The maximum number of tables to return in a single response.

• ResourceShareType – UTF-8 string (valid values: FOREIGN | ALL).

  Allows you to specify that you want to search the tables shared with your account. The allowable values are FOREIGN or ALL.

  • If set to FOREIGN, will search the tables shared with your account.

  • If set to ALL, will search the tables shared with your account, as well as the tables in yor local account.

Response

• NextToken – UTF-8 string.

  A continuation token, present if the current list segment is not the last.

• TableList – An array of Table objects.

  A list of the requested Table objects. The SearchTables response returns only the tables that you have access to.

Errors

• InternalServiceException

• InvalidInputException

• OperationTimeoutException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The catalog ID where the table resides.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Specifies the name of a database from which you want to retrieve partition indexes.

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Specifies the name of a table for which you want to retrieve the partition indexes.

• NextToken – UTF-8 string.

  A continuation token, included if this is a continuation call.

Response

• PartitionIndexDescriptorList – An array of PartitionIndexDescriptor objects.

  A list of index descriptors.

• NextToken – UTF-8 string.

  A continuation token, present if the current list segment is not the last.

Errors

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• EntityNotFoundException

• ConflictException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The catalog ID where the table resides.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Specifies the name of a database in which you want to create a partition index.

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Specifies the name of a table in which you want to create a partition index.

• PartitionIndex – Required: A PartitionIndex object.

  Specifies a PartitionIndex structure to create a partition index in an existing table.

Response

• No Response parameters.

Errors

• AlreadyExistsException

• InvalidInputException

• EntityNotFoundException

• ResourceNumberLimitExceededException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The catalog ID where the table resides.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Specifies the name of a database from which you want to delete a partition index.

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  Specifies the name of a table from which you want to delete a partition index.

• IndexName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the partition index to be deleted.

Response

• No Response parameters.

Errors

• InternalServiceException

• OperationTimeoutException

• InvalidInputException

• EntityNotFoundException

• ConflictException

• GlueEncryptionException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog where the partitions in question reside. If none is supplied, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the catalog database where the partitions reside.

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the partitions' table.

• ColumnNames – Required: An array of UTF-8 strings, not more than 100 strings.

  A list of the column names.

Response

• ColumnStatisticsList – An array of ColumnStatistics objects.

  List of ColumnStatistics that failed to be retrieved.

• Errors – An array of ColumnError objects.

  List of ColumnStatistics that failed to be retrieved.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog where the partitions in question reside. If none is supplied, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the catalog database where the partitions reside.

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the partitions' table.

• ColumnStatisticsList – Required: An array of ColumnStatistics objects, not more than 25 structures.

  A list of the column statistics.

Response

• Errors – An array of ColumnStatisticsError objects.

  List of ColumnStatisticsErrors.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException

Request

• CatalogId – Catalog id string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The ID of the Data Catalog where the partitions in question reside. If none is supplied, the Amazon account ID is used by default.

• DatabaseName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the catalog database where the partitions reside.

• TableName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the partitions' table.

• ColumnName – Required: UTF-8 string, not less than 1 or more than 255 bytes long, matching the Single-line string pattern.

  The name of the column.

Response

• No Response parameters.

Errors

• EntityNotFoundException

• InvalidInputException

• InternalServiceException

• OperationTimeoutException

• GlueEncryptionException