Skip to main content

SYS.REFLECTION_LINEAGE

Return a list of the Reflections that will also be refreshed if a refresh is triggered for a particular Reflection. For more information about which Reflections are listed, see Triggering Refreshes by Using the Reflection API, the Catalog API, or an SQL Command.

Syntax 
SELECT * FROM TABLE(sys.reflection_lineage('<reflection_id>'))

Parameter

<reflection_id> String

The ID of the Reflection. If you need to find a Reflection ID, see Obtaining Reflection IDs.

Example​

Return a list of Reflections that will be refreshed 
SELECT * FROM TABLE(sys.reflection_lineage('ebb8350d-9906-4345-ba19-7ad1da2a3cab'));
Example of a query result 
batch_number	reflection_id	                         reflection_name   dataset_name
           0	4a33df7c-be91-4c78-ba20-9cafc98a4a1d	 R_P3_web_sales    P3_web_sales
           1	82c32002-5040-4c2a-9430-36320b47b038     R_V6              V6
           2	2f039cd7-8bf7-468e-8d76-d9bf949d94db     R_V11	           V11
           2	3e9b03b8-6964-45b6-bab5-534088cfcff1	 R_V10	           V10

Columns​

ColumnData TypeDescription
batch_numberintegerFor the Reflection that will also be refreshed if the Reflection in the query is refreshed, the depth from its upstream base tables in the Dependency Graph. If a Reflection depends on other Reflections, it has a larger batch number and is refreshed later than the Reflections on which it depends. Reflections with the same batch number do not depend on each other, and their refreshes occur simultaneously in parallel.
reflection_idvarcharThe ID of the Reflection that will also be refreshed if the Reflection in the query is refreshed.
reflection_namevarcharThe name of the Reflection that will also be refreshed if the Reflection in the query is refreshed.
dataset_namevarcharThe name of the anchor dataset for the Reflection that will also be refreshed if the Reflection in the query is refreshed.