14 ms·
> Most of them are backed by object storage (S3/GCS) Redshift is backed by worker instances that have their own stores in what's basically an EC2 instance. It
by worker767424 6y ago
> Most of them are backed by object storage (S3/GCS)
Redshift is backed by worker instances that have their own stores in what's basically an EC2 instance. It's definitely not backed by S3 like Athena.
Bigquery and GCS are both built on top of Colossus, but they have different layers in between them.
- AtlasLion 6y agoSame applies to Teradata vantage on cloud.
- bpodgursky 6y agoSorry, probably should have been more precise. Meant to say: most users are going to interact with the warehouses via object storage for import and export of data. Since the object store APIs are almost identical across platforms, it doesn't matter that much which warehouse you actually use for production work. It's something that does massive SQL, imports data from S3, and exports data to S3.
- tomnipotent 6y ago> most users are going to interact with the warehouses via object storage for import and export of data. No, most are going to be using SQL IDE's to query and export data.
- EwanToo 6y agoWith the newer Redshift ra3 instances you use S3 backed storage with local SSD caching https://aws.amazon.com/redshift/features/ra3/ https://aws.amazon.com/redshift/features/ra3/