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