Table: aws_regions

Table that will hold all the AWS regions where IaSQL operates. AWS has the concept of a Region, which is a physical location around the world where we cluster data centers.

An user can specify which regions are enabled and which region is used as default.

Example

 SELECT * FROM aws_regions WHERE is_default = TRUE;
 UPDATE aws_regions SET is_default = TRUE WHERE region = 'us-east-1';

See

• https://aws.amazon.com/about-aws/global-infrastructure/regions_az/
• https://github.com/iasql/iasql/blob/main/test/modules/aws-account-integration.ts#L185
• https://github.com/iasql/iasql/blob/main/test/modules/aws-account-integration.ts#L196

Columns

• is_default: boolean

Identifies the default region. Only one region can be the default one

• is_enabled: boolean

Identifies if the region is enabled to interact with IaSQL or not

• region: string

AWS region