Skip to main content

SYS.PROJECT.REFLECTIONS

The sys.project.reflections table contains metadata for reflections in a project.

Syntax
SELECT * 
FROM sys.project.reflections

Example Output

reflection_idreflection_nametypestatusdataset_iddataset_namedataset_typesort_columnspartition_columnsdistribution_columnsdimensionsmeasuresdisplay_columnsexternal_reflectionnum_failuresarrow_cache
42478d5f-e749-41e1-8040-a6facc742073Raw ReflectionRAWCAN_ACCELERATEeb5e9ee9-dbd7-40a8-b48a-5aa0170383fdSamples."samples.dremio.com"."NYC-taxi-trips"PHYSICAL_DATASET_SOURCE_FOLDERempty textempty textempty textempty textempty textpickup_datetime, passenger_count, trip_distance_mi, fare_amount, tip_amount, total_amountempty text0false
57413f38-335b-4cba-86a4-d8c6dbcc205cRaw ReflectionRAWCAN_ACCELERATE395f67df-1c1a-476d-9f75-e1c8160ea930"@howard@dremio.com"."SF Incidents"VIRTUAL_DATASETempty textempty textempty textempty textempty textIncidntNum, Category, Descript, DayOfWeek, Date, Time, PdDistrict, Resolution, Address, X, Y, Locatiempty text0false
1f0c7e11-543d-4335-a56f-82d26731c49cNYC-Aggregation-ReflectionAGGREGATIONFAILEDzz5z9zz9-xyz7-40z8-x48y-9xx0170383zzSamples."samples.dremio.com"."NYC-taxi-trips"PHYSICAL_DATASET_SOURCE_FOLDERpickup_datetime, passenger_counttrip_distance_mipassenger_countpassenger_count, pickup_datetime, trip_distance_mitrip_distance_mi, total_amount, tip_amountpassenger_count, Sum_trip_distanceempty text6false

Fields

FieldData TypeDescription
reflection_idvarcharThe UUID to identify the reflection.
reflection_namevarcharThe user-defined name of the reflection.
typevarcharThe type of reflection.
Enum: AGGREGATION, RAW
statusvarcharThe 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_idvarcharThe UUID to identify the dataset that the reflection is on.
dataset_namevarcharThe path and name of the dataset that the reflection is on.
dataset_typevarcharThe 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_columnsvarcharThe list of columns that will be sorted on.
partition_columnsvarcharThe list of columns that the dataset is partioned on.
distribution_columnsvarcharThe list of distributed columns.
dimensionsvarcharThe list of dimension columns or expressions.
measuresvarcharThe list of measures.
display_columnsvarcharThe list of displayed columns.
external_reflectionvarcharThe field will be populated if the reflection is an external reflection.
num_failuresintegerThe number of recent failures.
arrow_cachebooleanThis value will be true if Arrow caching is enabled for the reflection; false otherwise.