I have a question about the aws_organizations_* tables. In each of these tables, there is a column called request_account_id. Do you know what this refers to? The documentation you provided here is not explicit, unfortunately.
For instance, I can see that consistently in these tables, (almost) every primary key is linked to exactly eight request_account_id in our case.
The request_account_id refers to the account that the request was made from. Probably in your case, you synced these tables from 8 AWS accounts.
In other words, behind the scenes, CloudQuery is making API requests to AWS. We have to specify the account when making the request, and you may get different results depending on the account the request is made from. In order for you to have all the data, we add the request_account_id. You may decide to only use one particular account, or you can compare the results for requests from different accounts; it’s up to you.
No, I didn’t get that… For example, if we take the aws_organizations_accounts table, there we are having two columns named “id” and “request_account_id”. What is the difference between these two columns here?
Here the id seems like a primary key, but the request_account_id is the thing which I don’t understand and why is this placed in the table in the first place?
Let’s use an example.
Let’s say we have three AWS accounts: account1, account2, account3.
When you run a sync for the aws_organizations_accounts table, we will ask AWS to list all the organization’s accounts 3 different times: once from account1, once from account2, and once from account3.
Due to factors like cross-account connections, the results of these different requests may vary. The request_account_id will inform you which account the request was made from. We provide this data so that you can potentially identify situations where an account is visible from another account when it actually shouldn’t be.
okay, that makes sense thank you
