Skip to main content

Stored Procedures, UDFs and Process assets

When working with Snowflake in Atlan, Stored Procedures and User-defined Functions work together with Process assets 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.

Snowflake Stored Procedures and User-defined Functions (UDFs) are often used inside Process assets, including SQL, Python, Java, JavaScript, and Scala implementations. These relationships form part of the queries that generate lineage information. Understanding these connections helps trace data flow and dependencies across your Snowflake environment.

How can I view stored procedure and UDF relationships in Atlan?​

You can view relationships between Stored Procedures, UDFs and Process assets in two ways:

  • From the Stored Procedure or UDF asset

    1. Navigate to the Stored Procedure or UDF asset in your Snowflake connection.
    2. Open the Related Assets tab.
    3. View the list of Process assets where the Stored Procedure or UDF 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 Stored Procedures and UDFs that contributed to that Process asset.

Are there any limitations to stored procedure and UDF lineage?​

Currently, only direct Stored Procedure and UDF calls are captured and visible. Dynamic queries with Stored Procedures and UDFs, and nested calls, aren't yet supported.

See also​

Need help​

If you can't find the answer you're looking for, contact Atlan support by submitting a request.