Common SSVID VMS positions and registry tables
N
Nate Miller
Currently in BQ it is hard to join VMS position tables to country registry tables. Typically each VMS dataset has a unique SSVID though this may differ between each VMS system.
However the corresponding field in the registry table is not labeled SSVID. Thus rather than a simple
USING (ssvid)
join, the user must know what field is used as the SSVID for each specific VMS system and then join based that field.Requiring this specific knowledge makes us more reliant on specific teammates who have this knowledge.
Hannah Linder
Nate Miller do you mean just changing the column name in the registry table to SSVID to help with this?
N
Nate Miller
Hannah Linder: Yes. I think there are additional updates we can make, but this is a very simple one.
Rollan has also been trying to document the current methods/queries needed to combine registry and VMS position data and we're hoping to identify ways that this might be streamlined. He'll have more info on this after he finishes with the Taiwan workshop next week and has a few days to finalize the initial analysis.