Table: aws_securitylake_data_lake

select
  encryption_key,
  replication_role_arn,
  s3_bucket_arn,
  status
from
  aws_securitylake_data_lake;

select
  distinct b.name as bucket_name,
  l.s3_bucket_arn,
  b.creation_date,
  b.bucket_policy_is_public,
  b.versioning_enabled,
  b.block_public_acls
from
  aws_securitylake_data_lake as l,
  aws_s3_bucket as b
where
  l.s3_bucket_arn = b.arn;

select
  l.encryption_key,
  l.replication_role_arn,
  l.s3_bucket_arn,
  l.status,
  r ->> 'RetentionPeriod' as retention_period,
  r ->> 'StorageClass' as storage_class
from
  aws_securitylake_data_lake as l,
  jsonb_array_elements(retention_settings) as r;

select
  encryption_key,
  replication_role_arn,
  s3_bucket_arn,
  status
from
  aws_securitylake_data_lake
where
  status = 'PENDING';