7.3.9 The rpd_tables Table

The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in HeatWave.

The rpd_tables table has these columns:

• ID

  A unique identifier for the table.

• SNAPSHOT_SCN

  The system change number (SCN) of the table snapshot. The SCN is an internal number that represents a point in time according to the system logical clock that the table snapshot was transactionally consistent with the source table.

• PERSISTED_SCN

  The SCN up to which changes are persisted.

• POOL_TYPE

  The load pool type of the table. Possible values are RAPID_LOAD_POOL_SNAPSHOT and RAPID_LOAD_POOL_TRANSACTIONAL.

• DATA_PLACEMENT_TYPE

  The data placement type.

• NROWS

  The number of rows that are loaded for the table. The value is set initially when the table is loaded, and updated as changes are propagated.

• LOAD_STATUS

  The load status of the table. Statuses include:

  • NOLOAD_RPDGSTABSTATE

    The table is not yet loaded.

  • LOADING_RPDGSTABSTATE

    The table is being loaded.

  • AVAIL_RPDGSTABSTATE

    The table is loaded and available for queries.

  • UNLOADING_RPDGSTABSTATE

    The table is being unloaded.

  • INRECOVERY_RPDGSTABSTATE

    The table is being recovered. After completion of the recovery operation, the table is placed back in the UNAVAIL_RPDGSTABSTATE state if there are pending recoveries.

  • STALE_RPDGSTABSTATE

    A failure during change propagation, and the table has become stale. See Section 2.2.7, “Change Propagation”

  • UNAVAIL_RPDGSTABSTATE

    The table is unavailable.

• LOAD_PROGRESS

  The load progress of the table expressed as a percentage value.

  For Lakehouse, the following values are returned:

  • 10%: the initialization phase is complete.

  • 10-70%: the transformation to native HeatWave format is in progress.

  • 70% - 80%: the transformation to native HeatWave format is complete and the aggregation phase is in progress.

  • 80-99%: the recovery phase is in progress.

  • 100%: data load is complete.

• SIZE_BYTES

  The amount of data loaded for the table, in bytes.

• TRANSFORMATION_BYTES:

  The total size of raw Lakehouse data transformed, in bytes.

• NROWS:

  The number of rows loaded to the external table.

• QUERY_COUNT

  The number of queries that referenced the table.

• LAST_QUERIED

  The timestamp of the last query that referenced the table.

• LOAD_START_TIMESTAMP

  The load start timestamp for the table.

• LOAD_END_TIMESTAMP

  The load completion timestamp for the table.

• RECOVERY_SOURCE

  Indicates the source of the last successful recovery for a table. The values are MySQL, that is InnoDB, or ObjectStorage.

• RECOVERY_START_TIMESTAMP

  The timestamp when the latest successful recovery started.

• RECOVERY_END_TIMESTAMP

  The timestamp when the latest successful recovery ended.

The rpd_tables table is read-only.