[New Feature]: Use Cognito authentication for Airflow and OGC APIs

[LucaCinquini]

PM Ticket Reference: unity-sds/unity-project-management#212

Description:

We need to be able to use the Cognito token for Airflow and OGS API requests - these should be proxied through the venue api gateway
Once the above is working, remove the Airflow login from the mid-proxy and prevent direct access to the mid-proxy

Explanation:
The preferred architecture is that the Airflow and OGC API endpoints are hidden behind the shared service and venue service proxies. The authorization token is retrieved from the shared services, and passed to the shared service proxy to enforce authentication. User permissions could be retrieved and passed to the OGC and Airflow APIs for further authorization.

[LucaCinquini]

As discussed during the PI, this task involves the following steps:

• Change the SPS ALBs for Airflow and OGC APIs to NLBs
• Configure the CS venue API gateway to proxy the SPS URLs to the SPS NLBs. For now, reuse the CS common Lambda Authorizer.
• Configure VPC link from the shared services to the venue services (is it done already?)
• Retrieve Cognito token from the shared services (provide examples via Python and CURL)
• Pass the Cognito token as part of an OGC and Airflow API to the API Gateway, demonstrate that the request is passed on to the SPS endpoints
• Update the integration tests to pass the Cognito token when invoking the Airflow and OGC APIs
• Remove direct access to the mid-level CS proxies

[LucaCinquini]

References:

• Unity Security Guidelines: https://unity-sds.gitbook.io/docs/developer-docs/common-services/docs/users-guide/security/unity-security-guidelines
• CS Lambda Authorizer: https://unity-sds.gitbook.io/docs/developer-docs/common-services/docs/users-guide/security/unity-security-guidelines
• Jupyter Notebook to work with unity-py including retrieving a token: https://github.com/unity-sds/mdps-tutorial/blob/main/jupyter-notebooks/tutorials/2_working_with_data.ipynb
• Other ways to get tokens: https://github.com/unity-sds/unity-docs/blob/main/developer-docs/common-services/docs/users-guide/security/editing-getting-cognito-jwt-tokens-in-command-line.md