Scaling AWS Redshift Concurrency With PostgreSQL
Paul Singman works as a platform engineer at Equinox, contributing to various projects related to ETL, Warehousing, API Development, Web Scraping, and DevOps. His primary tools of choice include Python, SQL, and AWS services to transform data from goulash to something structured and useful. Previously he has worked as a data engineer at several startups in NYC, was an instructor's assistant for a data science class at General Assembly, and competed in an Oscar's prediction competition on the website 538. While working he can often be found drinking tea from an obnoxiously large mug and listening to Lana Del Rey.
No video of the event yet, sorry!
Quick overview of Redshift and its Postgres heritage, similarities like SQL interface and differences like storage and scalability.
How we use Redshift as a data warehouse solution at Equinox to analyze data and provide insight.
Some strengths and short-comings of Redshift when it comes to data consumption and how we use Postgres to compensate, specifically with the dblink extension, to build our reporting lakeshore.
- 2019 March 21 09:00
- 50 min
- Postgres Conference