Dremio Cloud
Dremio Software
 
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_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.