[Feature] Configure views for subgraphs status data unioned from sharded databases

[datanexus-vincent]

Description

Derek (@Data-Nexus) had the great idea to create views for the different tables from the subgraphs schema that union all of the different foreign tables available in each shard's schema. For example, we have a subgraph_deployment_vw, subgraph_error_vw , subgraph_manifest_vw, subgraph_version_vw, and subgraph_vw. (Note: we didn't make one for subgraphs.subgraph_deployment_assigment because we found that table to be identical across all shards)

Would it be possible to automatically create views that union each foreign table from the shard_{shard name}_subgraphs schemas? That would make overview grafana dashboards for sharded deployments a lot easier to create and distribute.

Are you aware of any blockers that must be resolved before implementing this feature? If so, which? Link to any relevant GitHub issues.

If my other feature request is implemented, it would be useful to have a union view for public.ethereum_networks as well.

Some information to help us out

• Tick this box if you plan on implementing this feature yourself.
• I have searched the issue tracker to make sure this issue is not a duplicate.

[madumas]

these foreign tables may also be required for copy/grafting #4719

[lutter]

They are not needed for copy/grafting; graph-node handles that already by picking the right shard/foreign schema as needed.

The problem with these views is in how they interact with updates to the mappings, if they are ever needed: any update to them will drop the views. It'll require some more logic in this already very complicated piece of code. I'll have to think about that a bit.

[github-actions]

Looks like this issue has been open for 6 months with no activity. Is it still relevant? If not, please remember to close it.

[azf20]

Any thoughts on this one @lutter?

[kw1knode]

BUMP + 1000