
Some details
The data engineers team at Chrisranjana.com developed a AWS S3 Redshift solution for the client. The client wanted to design a robust data warehouse to handle Hundreds of millions of rows data transfer. The team of AWS AMAZON Redshift developers designed a redshift datawarehouse cluster. Redshift Distribution keys and Redshift Sort keys were suitably created. A subset of Redshift needed to be loaded into
Postgresql for use by business intelligence tool Tableau on a daily basis.Our team of redshift developers and redshift administrators completed this project according to the client',s specification and requirement.
The large data residing in AWS S3 storage was very efficiently loaded in amazon redshift using aws redshift spectrum which queries the S3 files directly. The AWS spectrum loaded data was referenced by REDSHIFT directly using redshift external tables. Our redshift developers in India created and architected the data flow for everday data synchronization.
The client was satisfied with both the quality and speed of the data transfer pipeline created by our aws redshift engineers.