Hi! DESC FASTDB is currently using diaForcedSourceId column (which exists in the alerts) for database ingestions. However this column is not available in the DP2 schema here. We’d like to ask if it’s possible to include this column in the * ForcedSourceOnDiaObject table in DP2 and future DRs. Thanks!
2 Likes
Because Alert Production and Data Release Production differ in how they parallelize force photometry, the way we generate AP’s diaForcedSourceIDs would cause collisions if used for DRP. So we don’t generate those IDs in DRP and instead use (objectId, visit) as a composite primary key for forced photometry. We’d like to avoid adding another column since ForcedSource gets very large in future DRs, but we’re open to hearing what would help make this useful.
2 Likes