Connect to RWB env prod db from metabase

avniproject / avni-infra

Other

0 stars 0 forks source link

Connect to RWB env prod db from metabase #25

Closed mahalakshme closed 5 months ago

mahalakshme commented 5 months ago

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 commented 5 months ago

@vinayvenu review this card and add any missing details.

1t5j0y commented 5 months ago

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 commented 5 months ago

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