Skip to content

Conversation

@smokentar
Copy link
Contributor

Summary

This PR is aimed to address #12414 by creating a composite primary key on aws_regions table comprising account_id and region.

With this key there will be one set of regions (27) per discovered AWS Account.
The reason why we're not limiting them to only one set of regions for all accounts is that different AWS Accounts can have different opt_in_status / enabled values for different regions.

@smokentar smokentar changed the title feat(aws): Define composite primary key for regions feat(aws)!: Define composite primary key for regions Jul 19, 2023
@github-actions
Copy link

This PR has the following changes to source plugin(s) tables:

  • ⚠️ BREAKING CHANGE: Table aws_regions: primary key constraint added to column account_id
  • ⚠️ BREAKING CHANGE: Table aws_regions: primary key constraint added to column region
  • ⚠️ BREAKING CHANGE: Table aws_regions: primary key constraint removed from column _cq_id

Copy link
Member

@erezrokah erezrokah left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

🚀

@erezrokah erezrokah added the automerge Automatically merge once required checks pass label Jul 19, 2023
@kodiakhq kodiakhq bot merged commit 681ea97 into cloudquery:main Jul 19, 2023
kodiakhq bot pushed a commit that referenced this pull request Jul 20, 2023
🤖 I have created a release *beep* *boop*
---


## [22.0.0](plugins-source-aws-v21.1.0...plugins-source-aws-v22.0.0) (2023-07-20)


### ⚠ BREAKING CHANGES

* **aws:** Define composite primary key for regions ([#12415](#12415))
* **aws:** Define primary key for s3_bucket_encryption_rules ([#12408](#12408))
* **aws:** Define primary key for dynamodb_table_continuous_backups ([#12409](#12409))
* **aws:** Define composite primary key for lambda_function_versions ([#12402](#12402))

### This Release has the Following Changes to Tables
- Table `aws_appconfig_deployment_strategies` was added
- Table `aws_dynamodb_table_continuous_backups`: primary key constraint added to column `table_arn` (:warning: breaking)
- Table `aws_dynamodb_table_continuous_backups`: primary key constraint removed from column `_cq_id` (:warning: breaking)
- Table `aws_lambda_function_versions`: primary key constraint added to column `function_arn` (:warning: breaking)
- Table `aws_lambda_function_versions`: primary key constraint added to column `version` (:warning: breaking)
- Table `aws_lambda_function_versions`: primary key constraint removed from column `_cq_id` (:warning: breaking)
- Table `aws_regions`: primary key constraint added to column `account_id` (:warning: breaking)
- Table `aws_regions`: primary key constraint added to column `region` (:warning: breaking)
- Table `aws_regions`: primary key constraint removed from column `_cq_id` (:warning: breaking)
- Table `aws_s3_bucket_encryption_rules`: primary key constraint added to column `bucket_arn` (:warning: breaking)
- Table `aws_s3_bucket_encryption_rules`: primary key constraint removed from column `_cq_id` (:warning: breaking)

### Features

* **aws:** Define composite primary key for lambda_function_versions ([#12402](#12402)) ([d1add18](d1add18))
* **aws:** Define composite primary key for regions ([#12415](#12415)) ([681ea97](681ea97))
* **aws:** Define primary key for dynamodb_table_continuous_backups ([#12409](#12409)) ([7d4a657](7d4a657))
* **aws:** Define primary key for s3_bucket_encryption_rules ([#12408](#12408)) ([a026b98](a026b98))


### Bug Fixes

* **sync:** Pass `DeterministicCQID` option to scheduler ([#12424](#12424)) ([eaac2e6](eaac2e6))
* Use correct name for `DeploymentStrategies` table ([#12428](#12428)) ([dda4205](dda4205))

---
This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

automerge Automatically merge once required checks pass

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants