MySQL HeatWave User Guide
The rpd_table_id table provides the ID, name,
and schema of the tables loaded in MySQL HeatWave.
The rpd_table_id table has these columns:
ID
A unique identifier for the table.
NAME
The full table name including the schema.
SCHEMA_NAME
The schema name.
TABLE_NAME
The table name.
MATERIALIZATION_QUERY
Available as of MySQL 9.3.0. The column contains the query used to create the MySQL HeatWave temporary table.
As of MySQL 9.5.0, the column contains the query used to create the materialized view or the MySQL HeatWave temporary table.
The rpd_table_id table is read-only.