When using MaterializeResult, how can I access a value or metadata in a downstream asset?

[seandavi]

When using MaterializeResult, can I access the associated metadata (or a single value) in a downstream asset? I use the MaterializeResult approach since all of my assets are larger than memory and typically stored as a file in cloud storage or as a database table.

[seandavi]

This question looks like it has been asked and answered in a different context. #14338

[oliverangelil]

You can do so using the value argument:

    return dg.MaterializeResult(
        value=df_agg,
        metadata={
            "Number of rows": dg.MetadataValue.int(len(df_agg))
        }
    )