SYS.REFLECTION_DEPENDENCIES

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

{{< codeheader "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.