You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently, there is no Dwh abstraction in the Analytics Reference Architecture and you need to provision Redshift L2 Construct with lots of additional resources to get a complete and usable setup.
We can implement a new construct called Dwh which bundle all the required resources with defaults but still customizable. It can be composed of:
Redshift cluster with a default parameter group (multiple priority queues, concurrency scaling,
KMS key for data encryption
Bucket for logs (should be an AraBucket singleton 'redshift-access-logs')
Default WLM configuration
IAM role for Spectrum
Schema pointing to Glue catalog
Default users for ETL, data engineer, data analyst, data scientist
Points to be investigated:
L2 alpha versus L1 Cfn based construct
Need for SSL enforcement
IAM authentication vs secret manager username/password
Currently, there is no Dwh abstraction in the Analytics Reference Architecture and you need to provision Redshift L2 Construct with lots of additional resources to get a complete and usable setup.
We can implement a new construct called
Dwhwhich bundle all the required resources with defaults but still customizable. It can be composed of:AraBucketsingleton 'redshift-access-logs')Points to be investigated: