When working with BigQuery in Atlan, routines and Process assets work together to provide comprehensive lineage tracking. This page answers common questions about how these components interact and how you can leverage their relationships for better data governance and understanding.

How are BigQuery routines related to Process assets in Atlan?

BigQuery routines (Stored Procedures, User-defined Functions, and Table-valued Functions) are often used inside Process assets since they form part of the queries that generate lineage information. Understanding these relationships helps trace data flow and dependencies across your BigQuery environment.

How can I view routine relationships in Atlan?

You can view relationships between routines and Process assets in two ways:

• From the routine asset

  1. Navigate to the routine asset in your BigQuery connection (Stored Procedure, UDF, or TVF).
  2. Open the Related Assets tab.
  3. View the list of Process assets where the routine is being used.

• From the lineage graph

  1. Open the lineage graph for any asset.
  2. Locate and click the Process node that represents the executed query.
  3. In the sidebar, open the Relations tab.
  4. View the routines that contributed to that Process asset.

Are there any limitations to routine lineage?

Currently, only direct routine calls are captured and visible. Dynamic queries with routines and nested routine calls aren't yet supported.