Class: Aws::DatabaseMigrationService::Types::TableStatistics

Inherits:
Struct
  • Object
show all
Includes:
Structure
Defined in:
lib/aws-sdk-databasemigrationservice/types.rb

Overview

Provides a collection of table statistics in response to a request by the ‘DescribeTableStatistics` operation.

Constant Summary collapse

SENSITIVE =
[]

Instance Attribute Summary collapse

Instance Attribute Details

#applied_ddlsInteger

The number of data definition language (DDL) statements used to build and modify the structure of your tables applied on the target.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#applied_deletesInteger

The number of delete actions applied on a target table.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#applied_insertsInteger

The number of insert actions applied on a target table.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#applied_updatesInteger

The number of update actions applied on a target table.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#ddlsInteger

The data definition language (DDL) used to build and modify the structure of your tables.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#deletesInteger

The number of delete actions performed on a table.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#full_load_condtnl_chk_failed_rowsInteger

The number of rows that failed conditional checks during the full load operation (valid only for migrations where DynamoDB is the target).

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#full_load_end_timeTime

The time when the full load operation completed.

Returns:

  • (Time)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#full_load_error_rowsInteger

The number of rows that failed to load during the full load operation (valid only for migrations where DynamoDB is the target).

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#full_load_reloadedBoolean

A value that indicates if the table was reloaded (‘true`) or loaded as part of a new full load operation (`false`).

Returns:

  • (Boolean)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#full_load_rowsInteger

The number of rows added during the full load operation.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#full_load_start_timeTime

The time when the full load operation started.

Returns:

  • (Time)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#insertsInteger

The number of insert actions performed on a table.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#last_update_timeTime

The last time a table was updated.

Returns:

  • (Time)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#schema_nameString

The schema name.

Returns:

  • (String)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#table_nameString

The name of the table.

Returns:

  • (String)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#table_stateString

The state of the tables described.

Valid states: Table does not exist | Before load | Full load | Table completed | Table cancelled | Table error | Table is being reloaded

Returns:

  • (String)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#updatesInteger

The number of update actions performed on a table.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#validation_failed_recordsInteger

The number of records that failed validation.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#validation_pending_recordsInteger

The number of records that have yet to be validated.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#validation_stateString

The validation state of the table.

This parameter can have the following values:

  • Not enabled – Validation isn’t enabled for the table in the migration task.

  • Pending records – Some records in the table are waiting for validation.

  • Mismatched records – Some records in the table don’t match between the source and target.

  • Suspended records – Some records in the table couldn’t be validated.

  • No primary key –The table couldn’t be validated because it has no primary key.

  • Table error – The table wasn’t validated because it’s in an error state and some data wasn’t migrated.

  • Validated – All rows in the table are validated. If the table is updated, the status can change from Validated.

  • Error – The table couldn’t be validated because of an unexpected error.

  • Pending validation – The table is waiting validation.

  • Preparing table – Preparing the table enabled in the migration task for validation.

  • Pending revalidation – All rows in the table are pending validation after the table was updated.

Returns:

  • (String)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#validation_state_detailsString

Additional details about the state of validation.

Returns:

  • (String)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end

#validation_suspended_recordsInteger

The number of records that couldn’t be validated.

Returns:

  • (Integer)


13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
# File 'lib/aws-sdk-databasemigrationservice/types.rb', line 13797

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :ddls,
  :applied_inserts,
  :applied_deletes,
  :applied_updates,
  :applied_ddls,
  :full_load_rows,
  :full_load_condtnl_chk_failed_rows,
  :full_load_error_rows,
  :full_load_start_time,
  :full_load_end_time,
  :full_load_reloaded,
  :last_update_time,
  :table_state,
  :validation_pending_records,
  :validation_failed_records,
  :validation_suspended_records,
  :validation_state,
  :validation_state_details)
  SENSITIVE = []
  include Aws::Structure
end