On this page

    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.