Skip to content

CI: script to merge .md files with AWS AMIs #261

New issue
New issue
Open
Feature
Open
CI: script to merge .md files with AWS AMIs#261
Feature
Labels
awsAmazon Web Services supportenhancementNew feature or requestgood first issueGood for newcomers
@andrewlukoshko

Description

@andrewlukoshko
andrewlukoshko
opened on Sep 9, 2025

When we copy AWS AMIs to regions we get .md file that looks like this:
x86_64:

Distribution|Version|Region|AMI ID|Arch
-|-|-|-|-
AlmaLinux OS |10.20250904.0 |af-south-1 |ami-0da9a5e5a781c3ac1 |x86_64
AlmaLinux OS |10.20250904.0 |ap-east-1 |ami-000883822c381194b |x86_64
AlmaLinux OS |10.20250904.0 |ap-northeast-1 |ami-0428a5263b136c68c |x86_64
AlmaLinux OS |10.20250904.0 |ap-northeast-2 |ami-028ba31c7b6434d4f |x86_64
AlmaLinux OS |10.20250904.0 |ap-northeast-3 |ami-042f1bbc7bb15b9b5 |x86_64
AlmaLinux OS |10.20250904.0 |ap-south-1 |ami-0510f5003f3872204 |x86_64
AlmaLinux OS |10.20250904.0 |ap-south-2 |ami-08a163dcb877f1290 |x86_64
AlmaLinux OS |10.20250904.0 |ap-southeast-1 |ami-0ffec0fadb5a030f5 |x86_64
AlmaLinux OS |10.20250904.0 |ap-southeast-2 |ami-06820b5c922585652 |x86_64
AlmaLinux OS |10.20250904.0 |ap-southeast-3 |ami-03cce2e9a1ed163a2 |x86_64
AlmaLinux OS |10.20250904.0 |ap-southeast-4 |ami-05074fcd4508aee43 |x86_64
AlmaLinux OS |10.20250904.0 |ap-southeast-5 |ami-0a29761adc8e26261 |x86_64
AlmaLinux OS |10.20250904.0 |ap-southeast-7 |ami-0b23dc58cf6713fca |x86_64
AlmaLinux OS |10.20250904.0 |ca-central-1 |ami-0d0d5c9cbb36ccef8 |x86_64
AlmaLinux OS |10.20250904.0 |ca-west-1 |ami-0aa2abd5bd8e4ad87 |x86_64
AlmaLinux OS |10.20250904.0 |eu-central-1 |ami-00450c70966e41e48 |x86_64
AlmaLinux OS |10.20250904.0 |eu-central-2 |ami-0b2e9c1fdb24d5155 |x86_64
AlmaLinux OS |10.20250904.0 |eu-north-1 |ami-0d5885d4023a76daa |x86_64
AlmaLinux OS |10.20250904.0 |eu-south-1 |ami-031cd101e2cb8477d |x86_64
AlmaLinux OS |10.20250904.0 |eu-south-2 |ami-0e935acf3644949c4 |x86_64
AlmaLinux OS |10.20250904.0 |eu-west-1 |ami-02f7ae09f3a4bf0ae |x86_64
AlmaLinux OS |10.20250904.0 |eu-west-2 |ami-0d5334c0cf0cb18b9 |x86_64
AlmaLinux OS |10.20250904.0 |eu-west-3 |ami-044302f7596b90be7 |x86_64
AlmaLinux OS |10.20250904.0 |il-central-1 |ami-05c71e49fa561e7a2 |x86_64
AlmaLinux OS |10.20250904.0 |me-central-1 |ami-0a45fc2d5cd03dd44 |x86_64
AlmaLinux OS |10.20250904.0 |me-south-1 |ami-0f4dff58bc4135130 |x86_64
AlmaLinux OS |10.20250904.0 |mx-central-1 |ami-098f08a442459759f |x86_64
AlmaLinux OS |10.20250904.0 |sa-east-1 |ami-07273d90dcdbd6b7b |x86_64
AlmaLinux OS |10.20250904.0 |us-east-1 |ami-0377ff0635575a13b |x86_64
AlmaLinux OS |10.20250904.0 |us-east-2 |ami-0a2c591ad837d4475 |x86_64
AlmaLinux OS |10.20250904.0 |us-west-1 |ami-0d63ade8f639c4325 |x86_64
AlmaLinux OS |10.20250904.0 |us-west-2 |ami-05a51903c4ad0a56d |x86_64

aarch64:

Distribution|Version|Region|AMI ID|Arch
-|-|-|-|-
AlmaLinux OS |10.20250904.0 |af-south-1 |ami-0da0a0ce1a8fe6f07 |aarch64
AlmaLinux OS |10.20250904.0 |ap-east-1 |ami-0c8d3b975c6e9c276 |aarch64
AlmaLinux OS |10.20250904.0 |ap-northeast-1 |ami-02fd0fb4892fcda3f |aarch64
AlmaLinux OS |10.20250904.0 |ap-northeast-2 |ami-0b4cc53c6d1f786eb |aarch64
AlmaLinux OS |10.20250904.0 |ap-northeast-3 |ami-047f3f23d8e75afa9 |aarch64
AlmaLinux OS |10.20250904.0 |ap-south-1 |ami-0b46e38586656e81d |aarch64
AlmaLinux OS |10.20250904.0 |ap-south-2 |ami-0bfb6403f8f9ed3a9 |aarch64
AlmaLinux OS |10.20250904.0 |ap-southeast-1 |ami-00f835d071cacac97 |aarch64
AlmaLinux OS |10.20250904.0 |ap-southeast-2 |ami-0feab05def5f6fb99 |aarch64
AlmaLinux OS |10.20250904.0 |ap-southeast-3 |ami-037420e2f1ba57b9b |aarch64
AlmaLinux OS |10.20250904.0 |ap-southeast-4 |ami-0758fafa317c939a0 |aarch64
AlmaLinux OS |10.20250904.0 |ap-southeast-5 |ami-0209dd221eef5476e |aarch64
AlmaLinux OS |10.20250904.0 |ap-southeast-7 |ami-05251ad5aa45fe4d7 |aarch64
AlmaLinux OS |10.20250904.0 |ca-central-1 |ami-04cf35004b8b17817 |aarch64
AlmaLinux OS |10.20250904.0 |ca-west-1 |ami-0fea5a15d35b24f3e |aarch64
AlmaLinux OS |10.20250904.0 |eu-central-1 |ami-01bc18fba9443b97f |aarch64
AlmaLinux OS |10.20250904.0 |eu-central-2 |ami-00d671db039133e38 |aarch64
AlmaLinux OS |10.20250904.0 |eu-north-1 |ami-0e105edd77745154f |aarch64
AlmaLinux OS |10.20250904.0 |eu-south-1 |ami-0a545f9b81d4507f2 |aarch64
AlmaLinux OS |10.20250904.0 |eu-south-2 |ami-099329f35647ab365 |aarch64
AlmaLinux OS |10.20250904.0 |eu-west-1 |ami-027cabcb4b3f8d3c3 |aarch64
AlmaLinux OS |10.20250904.0 |eu-west-2 |ami-062d53f944197164e |aarch64
AlmaLinux OS |10.20250904.0 |eu-west-3 |ami-0abde3d00c0a36020 |aarch64
AlmaLinux OS |10.20250904.0 |il-central-1 |ami-014f549761c560672 |aarch64
AlmaLinux OS |10.20250904.0 |me-central-1 |ami-02e46d50c460d1171 |aarch64
AlmaLinux OS |10.20250904.0 |me-south-1 |ami-0057e03e287f113aa |aarch64
AlmaLinux OS |10.20250904.0 |mx-central-1 |ami-053bf05acb5eb8386 |aarch64
AlmaLinux OS |10.20250904.0 |sa-east-1 |ami-080daee5a04d9395d |aarch64
AlmaLinux OS |10.20250904.0 |us-east-1 |ami-0772643fa72af618f |aarch64
AlmaLinux OS |10.20250904.0 |us-east-2 |ami-00b34211c7daa726c |aarch64
AlmaLinux OS |10.20250904.0 |us-west-1 |ami-000bec82d4ebca944 |aarch64
AlmaLinux OS |10.20250904.0 |us-west-2 |ami-0bb93e66e42d8fbb5 |aarch64

We need to merge them to get single table grouped by region where x86_64 comes first and aarch64 second.
Like this:

| Distribution | Version       | Region         | AMI ID                | Arch    |
| ------------ | ------------- | -------------- | --------------------- | ------- |
| AlmaLinux OS | 10.20250904.0 | af-south-1     | ami-0da9a5e5a781c3ac1 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | af-south-1     | ami-0da0a0ce1a8fe6f07 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-east-1      | ami-000883822c381194b | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-east-1      | ami-0c8d3b975c6e9c276 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-northeast-1 | ami-0428a5263b136c68c | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-northeast-1 | ami-02fd0fb4892fcda3f | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-northeast-2 | ami-028ba31c7b6434d4f | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-northeast-2 | ami-0b4cc53c6d1f786eb | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-northeast-3 | ami-042f1bbc7bb15b9b5 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-northeast-3 | ami-047f3f23d8e75afa9 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-south-1     | ami-0510f5003f3872204 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-south-1     | ami-0b46e38586656e81d | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-south-2     | ami-08a163dcb877f1290 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-south-2     | ami-0bfb6403f8f9ed3a9 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-1 | ami-0ffec0fadb5a030f5 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-1 | ami-00f835d071cacac97 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-2 | ami-06820b5c922585652 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-2 | ami-0feab05def5f6fb99 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-3 | ami-03cce2e9a1ed163a2 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-3 | ami-037420e2f1ba57b9b | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-4 | ami-05074fcd4508aee43 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-4 | ami-0758fafa317c939a0 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-5 | ami-0a29761adc8e26261 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-5 | ami-0209dd221eef5476e | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-7 | ami-0b23dc58cf6713fca | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ap-southeast-7 | ami-05251ad5aa45fe4d7 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ca-central-1   | ami-0d0d5c9cbb36ccef8 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ca-central-1   | ami-04cf35004b8b17817 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | ca-west-1      | ami-0aa2abd5bd8e4ad87 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | ca-west-1      | ami-0fea5a15d35b24f3e | aarch64 |
| AlmaLinux OS | 10.20250904.0 | eu-central-1   | ami-00450c70966e41e48 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | eu-central-1   | ami-01bc18fba9443b97f | aarch64 |
| AlmaLinux OS | 10.20250904.0 | eu-central-2   | ami-0b2e9c1fdb24d5155 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | eu-central-2   | ami-00d671db039133e38 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | eu-north-1     | ami-0d5885d4023a76daa | x86_64  |
| AlmaLinux OS | 10.20250904.0 | eu-north-1     | ami-0e105edd77745154f | aarch64 |
| AlmaLinux OS | 10.20250904.0 | eu-south-1     | ami-031cd101e2cb8477d | x86_64  |
| AlmaLinux OS | 10.20250904.0 | eu-south-1     | ami-0a545f9b81d4507f2 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | eu-south-2     | ami-0e935acf3644949c4 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | eu-south-2     | ami-099329f35647ab365 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | eu-west-1      | ami-02f7ae09f3a4bf0ae | x86_64  |
| AlmaLinux OS | 10.20250904.0 | eu-west-1      | ami-027cabcb4b3f8d3c3 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | eu-west-2      | ami-0d5334c0cf0cb18b9 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | eu-west-2      | ami-062d53f944197164e | aarch64 |
| AlmaLinux OS | 10.20250904.0 | eu-west-3      | ami-044302f7596b90be7 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | eu-west-3      | ami-0abde3d00c0a36020 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | il-central-1   | ami-05c71e49fa561e7a2 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | il-central-1   | ami-014f549761c560672 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | me-central-1   | ami-0a45fc2d5cd03dd44 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | me-central-1   | ami-02e46d50c460d1171 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | me-south-1     | ami-0f4dff58bc4135130 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | me-south-1     | ami-0057e03e287f113aa | aarch64 |
| AlmaLinux OS | 10.20250904.0 | mx-central-1   | ami-098f08a442459759f | x86_64  |
| AlmaLinux OS | 10.20250904.0 | mx-central-1   | ami-053bf05acb5eb8386 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | sa-east-1      | ami-07273d90dcdbd6b7b | x86_64  |
| AlmaLinux OS | 10.20250904.0 | sa-east-1      | ami-080daee5a04d9395d | aarch64 |
| AlmaLinux OS | 10.20250904.0 | us-east-1      | ami-0377ff0635575a13b | x86_64  |
| AlmaLinux OS | 10.20250904.0 | us-east-1      | ami-0772643fa72af618f | aarch64 |
| AlmaLinux OS | 10.20250904.0 | us-east-2      | ami-0a2c591ad837d4475 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | us-east-2      | ami-00b34211c7daa726c | aarch64 |
| AlmaLinux OS | 10.20250904.0 | us-west-1      | ami-0d63ade8f639c4325 | x86_64  |
| AlmaLinux OS | 10.20250904.0 | us-west-1      | ami-000bec82d4ebca944 | aarch64 |
| AlmaLinux OS | 10.20250904.0 | us-west-2      | ami-05a51903c4ad0a56d | x86_64  |
| AlmaLinux OS | 10.20250904.0 | us-west-2      | ami-0bb93e66e42d8fbb5 | aarch64 |

The code should be written in either Python or Bash.

Metadata

Metadata

Assignees

No one assigned

    Labels

    awsAmazon Web Services supportenhancementNew feature or requestgood first issueGood for newcomers

    Type

    Feature

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions