5.4.8 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.

    • UNAVAIL_RPDGSTABSTATE

      The table is unavailable.

  • LOAD_PROGRESS

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

  • SIZE_BYTES

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

  • 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.

The rpd_tables table is read-only.