Using Snowflake IO Manager... when an asset has a ...
# ask-community
c
Using Snowflake IO Manager... when an asset has a dependency, how does it know what to load? Does it take the Query Metadata from the asset upon which it depends and execute that query to provide the dependency as a dataframe to the dependent asset? Or is there additional metadata stored that indicates to the dependent where/how to find the dependency?
j
we determine the path to the table based on the database and schema provided as configuration or key prefixes, and the table name is the name of the asset. Then we execute a select query to get the table. It’s the same query that’s stored as the Query Metadata, but we just re-generate the query when loading vs introspect on the query metadata from the upstream asset
c
Thank you, Jamie. You've been a great help with the various sticking point I've hit.
🎉 1