Which problem is this feature request solving?
Provide a cache that will speed up table sync operations for larger customers with hundreds/thousands of accounts and mitigate the chance of API rate limiting against the organizations namespace.
Describe the solution you'd like
A new option in the org block of the AWS plugin that when enabled will retrieve the account IDs form the aws_organizations_accounts table. Only account IDs with a status of ACTIVE should be included in the retrieval. This option would be ignored if the sync job includes the aws_organizations_accounts job in the list of tables to update.
Pull request (optional)