accelerated_count | integer | Number of jobs accelerated by the reflection. |
acceleration_status | varchar | Status of the reflection's availability for accelerating queries. |
arrow_cache | boolean | This value will be true if Arrow caching is enabled for the reflection; false otherwise. |
available_until | timestamp | Date and time that the reflection expires, in UTC format. |
considered_count | integer | Number of jobs that considered the reflection during planning. |
created_at | timestamp | Date and time that the reflection was created, in UTC format. |
current_footprint_bytes | bigint | Data size of the latest reflection job (if one exists), in bytes. |
dataset_id | varchar | The UUID to identify the dataset that the reflection is on. |
dataset_name | varchar | The path and name of the dataset that the reflection is on. |
dataset_type | varchar | The type of dataset that the reflection has been created on. Enum: PHYSICAL_DATASET_HOME_FILE, PHYSICAL_DATASET_SOURCE_FILE, PHYSICAL_DATASET_SOURCE_FOLDER, VIRTUAL_DATASET |
dimensions | varchar | The list of dimension columns or expressions. |
display_columns | varchar | The list of displayed columns. |
distribution_columns | varchar | The list of distributed columns. |
external_reflection | varchar | The field will be populated if the reflection is an external reflection. |
last_failure_message | varchar | The error message of the last failed reflection refresh, which is cleared out once one reflection refresh succeeds. |
last_failure_stack | varchar | The stack trace of the last failed reflection refresh, which is cleared out once one reflection refresh succeeds. |
last_refresh_duration_millis | bigint | Duration of the most recent refresh for the reflection, in milliseconds. |
last_refresh_from_table | timestamp | Date and time of the last refresh of the tables from which the reflection is ultimately derived, in UTC format. |
matched_count | integer | Number of jobs that matched the reflection during planning. |
measures | varchar | The list of measures. |
num_failures | integer | The number of recent failures. |
partition_columns | varchar | The list of columns that the dataset is partioned on. |
record_count | bigint | Number of records returned for the latest reflection. |
reflection_id | varchar | The UUID to identify the reflection. |
reflection_name | varchar | The user-defined name of the reflection. |
refresh_method | varchar | The method used for the most recent refresh of the reflection. For new reflections, the value is NONE . For more information, see Refreshing Reflections. |
refresh_status | varchar | Status of the reflection refresh. |
sort_columns | varchar | The list of columns that will be sorted on. |
status | varchar | The status of the reflection based on the last time the reflection was used. Enum: CAN_ACCELERATE, CAN_ACCELERATE_WITH_FAILURES, REFRESHING, FAILED, EXIPRED, DISABLED, INVALID, INCOMPLETE, CANNOT_ACCELERATE_SCHEDULED, CANNOT_ACCELERATE_MANUAL |
total_footprint_bytes | bigint | Data size of all reflection jobs that have not been pruned (if any exist), in bytes. |
type | varchar | The type of reflection. Enum: AGGREGATION, RAW |
updated_at | timestamp | Date and time that the reflection was last updated, in UTC format. |