Are these different companies that belong to the same corporate group part of the same AWS organization, or do they have their own independent AWS organizations?
If they are part of the same AWS organization and just have their own independent AWS accounts, then yes it is possible to share VPCs as documented here - https://docs.aws.amazon.com/vpc/latest/userguide/vpc-sharing.html
This blog is also worth a read - https://aws.amazon.com/blogs/networking-and-content-delivery/vpc-sharing-a-new-approach-to-multiple-accounts-and-vpc-management/
If these are in different AWS organizations, you can create one account and VPC in the corporate organization where you will deploy the data warehouse and peer it with VPCs from other sub-companies' AWS accounts. That way you will be able to move data to the data warehouse in the corporate account VPC.
VPC peering with VPCs in other organizations can put you out of compliance with NIST4 as per this from Trend Micro - https://www.trendmicro.com/cloudoneconformity/knowledge-base/aws/VPC/vpc-peering-connections-to-accounts-outside-aws-organizations.html
What is the best way to generate a visual diagram of the AWS environment which includes VPC, VPNAccepted Answerasked 2 years ago
[CDK Pipelines] Is it possible to run a Codebuild step without an input?asked 8 months ago
Is it possible to create a workmail "catch-all" accountasked 24 days ago
Is it better to have a single Direct Connect Gateway or multiple Direct Connect Gateways?Accepted AnswerEXPERTasked 4 months ago
Is it possible to create a Public Graphql end point using AWS AppSync?asked 3 months ago
Is it possible to kill/stop a running lambda function?asked 5 years ago
Shared VPC for multiple CompaniesAccepted Answerasked a month ago
Can I set a security group for each workspace that is launched?asked 5 months ago
Is it possible for RDS Proxy to ignore a reader instance?asked 4 months ago
Is it possible to schedule the number of instances in a fleet?asked a year ago