Connect to RWB env prod db from metabase

[mahalakshme]

https://avni.freshdesk.com/a/tickets/3762

• Connect to RWB env prod db from metabase by applying appropriate SSH tunnelling/VPC config as needed.

Note: Metabase and RWB prod db are in different AWS accounts

Acceptance criteria

As a metabase user of rwb in reporting.avniproject.org, I should be able to query the avni gramin database.

One option to do this is to make the db public and add security groups for metabase to be able to contact it.

[mahalakshme]

@vinayvenu review this card and add any missing details.

[1t5j0y]

Discussed with @Balamuruganjeevi to continue to use VPC peering (mechanism currently used by metabase to talk to Avni staging/prerelease/prod) to set this up which can be used cross account as well.

[1t5j0y]

Verified by creating "RWB DB Conn Check" in metabase connecting to RWB prod db.