SYS.PROJECT.REFLECTIONS
The sys.project.reflections table contains metadata for reflections in a project.
SELECT *
FROM sys.project.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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42478d5f-e749-41e1-8040-a6facc742073 | Raw Reflection | RAW | CAN_ACCELERATE | eb5e9ee9-dbd7-40a8-b48a-5aa0170383fd | Samples."samples.dremio.com"."NYC-taxi-trips" | PHYSICAL_DATASET_SOURCE_FOLDER | empty text | empty text | empty text | empty text | empty text | pickup_datetime, passenger_count, trip_distance_mi, fare_amount, tip_amount, total_amount | empty text | 0 | false |
| 57413f38-335b-4cba-86a4-d8c6dbcc205c | Raw Reflection | RAW | CAN_ACCELERATE | 395f67df-1c1a-476d-9f75-e1c8160ea930 | "@howard@dremio.com"."SF Incidents" | VIRTUAL_DATASET | empty text | empty text | empty text | empty text | empty text | IncidntNum, Category, Descript, DayOfWeek, Date, Time, PdDistrict, Resolution, Address, X, Y, Locati | empty text | 0 | false |
| 1f0c7e11-543d-4335-a56f-82d26731c49c | NYC-Aggregation-Reflection | AGGREGATION | FAILED | zz5z9zz9-xyz7-40z8-x48y-9xx0170383zz | Samples."samples.dremio.com"."NYC-taxi-trips" | PHYSICAL_DATASET_SOURCE_FOLDER | pickup_datetime, passenger_count | trip_distance_mi | passenger_count | passenger_count, pickup_datetime, trip_distance_mi | trip_distance_mi, total_amount, tip_amount | passenger_count, Sum_trip_distance | empty text | 6 | false |
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 partioned on. |
| 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. |