[Canned reports][User management] Login into Metabase using same Cognito credentials

[mahalakshme]

AC:

• Login into Metabase should work with the credentials used in Avni
• Add the working code(no need to be integration) for the below in a branch
• Identify the risks and flows that might not work

Technical suggestion:

• OAuth2 is inbuilt supported by Metabase only in the Enterprise and Pro editions. So the below can be done:
• Whenever a user is created in Cognito in a Metabase usergroup, using AWS lambda create a Metabase user with same credentials for that user
  • Configure a reverse proxy for Metabase, so all traffic to it is routed via the proxy
  • Use an OAuth Proxy tool like oauth2-proxy to handle the OAuth flow with AWS Cognito and login into Metabase.

Useful links:

metabase/metabase#7662 (comment)

Inputs:

• superset
• create embedded dashboard - org-dashboard mapping
  - go via the server - for URL authentication
• common login