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

Inherits:
Struct
  • Object
show all
Defined in:
gems/aws-sdk-databasemigrationservice/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

#ddlsInteger

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

Returns:

  • (Integer)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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 all | Table updates | Table is being reloaded

Returns:

  • (String)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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)


8490
8491
8492
8493
8494
8495
8496
8497
8498
8499
8500
8501
8502
8503
8504
8505
8506
8507
8508
8509
8510
8511
8512
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 8490

class TableStatistics < Struct.new(
  :schema_name,
  :table_name,
  :inserts,
  :deletes,
  :updates,
  :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