https://dagster.io/ logo
s

sephi

07/22/2020, 6:16 PM
Hi, As part of the monitoring our pipeline - we would like to read some assets from previous runs, that were generated from yielding
materialization
. We are having difficulty finding the location of the 
Assets
in postgesql. In the db we can see the following tables: snapshots, runs, run_tags, event_logs. But we could not locate the assets in any of the tables. Any assistance would be appreciated.
p

prha

07/22/2020, 6:17 PM
Assets are an index on the
event_logs
table in postgres
Should be
idx_asset_key
, which indexes the
asset_key
column
These are only populated for
AssetMaterialization
/
Materialization
events
s

sephi

07/23/2020, 5:33 AM
Great! exactly what we were looking for
2 Views