On this page

    SYS.REFLECTION_DEPENDENCIES

    The sys.reflection_dependencies table contains metadata for reflection dependencies in the Dremio instance.

    Syntax
    SELECT * 
    FROM sys.reflection_dependencies
    

    Example Output

    reflection_iddependency_iddependency_typedependency_path
    58ef99d2-ac06-4886-b76f-da729b872db0be2f17da-6c09-4eb9-9fba-db5a76d6d773DATASET[@dremio, nested_nested1]
    cc8b4c93-c028-427e-b773-8e5aab75c13067fedcc9-841f-41d9-8344-03b826c8c9c2DATASET[Samples, samples.dremio.com, SF_incidents2016.json]
    2acccebb-9fe2-4864-b714-664434b0ed373a276914-bf82-4447-b146-336e950e96e0DATASET[Samples, samples.dremio.com, NYC-taxi-trips]
    31e1a2ec-4815-4efb-805d-00c427d000772ece1ecb-e436-46c1-97dd-ffe50d2d96b2DATASET[Samples, samples.dremio.com, zips.json]
    4d42481b-802a-437d-a1c9-9a9dd8d9be03432d5845-b258-4268-b6ab-7681c9afa184DATASET[@dremio, test_parquet]

    Fields

    FieldData TypeDescription
    reflection_idvarcharThe UUID to identify the reflection.
    dependency_idvarcharThe UUID to identify the reflection dependency, which can be a dataset or a reflection.
    dependency_typevarcharThe dependency type.
    Enum: DATASET, REFLECTION
    dependency_pathvarcharThe path of the dependency.