SYS.REFLECTIONS
The sys.reflections table contains metadata for reflections in the Dremio instance.
SyntaxSELECT *
FROM sys.reflections
Example Output
| reflection_id | reflection_name | type | status | dataset_id | dataset_name | dataset_type | sort_columns | partition_columns | distribution_columns | dimensions | measures | display_columns | external_reflection | num_failures | arrow_cache |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4c78569a-158b-413d-afa9-4424b0e51a72 | ref_union | AGGREGATION | CAN_ACCELERATE | c50508c3-b82d-48a9-b5d0-d0ce5cb37da9 | sam.unionview | VIRTUAL_DATASET | A | B | 0 | false | |||||
| 74de4114-27e0-4db9-ab88-60cf9a689dd0 | taxi_reflection | AGGREGATION | CANNOT_ACCELERATE_MANUAL | 9ad9e8be-b584-468a-97ff-34e58e8c1ba8 | Samples."samples.dremio.com"."NYC-taxi-trips-iceberg" | PHYSICAL_DATASET_SOURCE_FOLDER | MONTH(pickup_datetime) | pickup_datetime | "passenger_count | trip_distance_mi | fare_amount | tip_amount | total_amount | ||
| f79d8196-2f60-4aa7-beb1-eb69466cf0c8 | Raw Reflection | RAW | FAILED | 65541138-07ec-496c-ba5e-318fee7d225d | s3."samples.dremio.com"."NYC-taxi-trips-iceberg" | PHYSICAL_DATASET_SOURCE_FOLDER | passenger_count | "pickup_datetime | passenger_count | trip_distance_mi | fare_amount | ||||
| 438bfbaa-2bf1-4ba9-9759-bd16399a3869 | Aggregation Reflection | AGGREGATION | CAN_ACCELERATE | 4da4eb8d-be0a-487b-99d6-68827f806c9a | my_space.weather | VIRTUAL_DATASET | "DayOfWeek | Descript" | DayOfWeek | 0 |
Fields
| Field | Data Type | Description |
|---|---|---|
| reflection_id | varchar | The UUID to identify the reflection. |
| reflection_name | varchar | The user-defined name of the reflection. |
| type | varchar | The type of reflection. Enum: AGGREGATION, RAW |
| 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 |
| 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 |
| sort_columns | varchar | The list of columns that will be sorted on. |
| partition_columns | varchar | The list of columns that the dataset is partitioned on. Shows partition transforms, if any are set, on the columns. |
| distribution_columns | varchar | The list of distributed columns. |
| dimensions | varchar | The list of dimension columns or expressions. |
| measures | varchar | The list of measures. |
| display_columns | varchar | The list of displayed columns. |
| external_reflection | varchar | The field will be populated if the reflection is an external reflection. |
| num_failures | integer | The number of recent failures. |
| arrow_cache | boolean | This value will be true if Arrow caching is enabled for the reflection; false otherwise. |