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

    note:

    In Dremio 20+, the sys.dependencies table has been renamed to sys.reflection_dependencies.

    Example Output

    reflection_id dependency_id dependency_type dependency_path
    58ef99d2-ac06-4886-b76f-da729b872db0 be2f17da-6c09-4eb9-9fba-db5a76d6d773 DATASET [@dremio, nested_nested1]
    cc8b4c93-c028-427e-b773-8e5aab75c130 67fedcc9-841f-41d9-8344-03b826c8c9c2 DATASET [Samples, samples.dremio.com, SF_incidents2016.json]
    2acccebb-9fe2-4864-b714-664434b0ed37 3a276914-bf82-4447-b146-336e950e96e0 DATASET [Samples, samples.dremio.com, NYC-taxi-trips]
    31e1a2ec-4815-4efb-805d-00c427d00077 2ece1ecb-e436-46c1-97dd-ffe50d2d96b2 DATASET [Samples, samples.dremio.com, zips.json]
    4d42481b-802a-437d-a1c9-9a9dd8d9be03 432d5845-b258-4268-b6ab-7681c9afa184 DATASET [@dremio, test_parquet]

    Fields

    Field Data Type Description
    reflection_id varchar The UUID to identify the reflection.
    dependency_id varchar The UUID to identify the reflection dependency, which can be a dataset or a reflection.
    dependency_type varchar The dependency type.
    Enum: DATASET, REFLECTION
    dependency_path varchar The path of the dependency.