- Newest
- Most votes
- Most comments
Usually Storage Optimized EC2 Instances(Specifically I3 and I3en) would be best choice for data warehousing use cases. If you look at Storage Optimized Instances section at Amazon EC2 Instance Types, these provide NVMe SSD storage which would be way faster than traditional SSD storage option generally available in EBS.
There may be other factors and considerations as well, which can come into play but as a general guidance first choice should be Storage Optimized Instances, if they fulfill your use case requirements. Also, you can consider D2 and D3 instances under Storage Optimized Instances category if they fit better than I3 and I3en for your use cases.
Full list of Amazon EC2 Instance type is listed here.
Hope you find this information helpful.
Comment here if you have additional questions, happy to help.
Abhishek
Relevant content
- Accepted Answerasked 3 years ago
- asked 10 months ago
- Accepted Answerasked a year ago
- Accepted Answerasked 4 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 2 years ago
Just ensure you have a backup/bcp strategy as local storage isn’t highly available.