A Billion NYC Taxi and Uber Rides in AWS Redshift

Quite frankly, for data of this scale, PostgreSQL is more than adequate on a modern machine (although the OP&#x27;s step-by-step guide is surely help for those new to Redshift)<p>For those interested in funny and insight analyses of the data, check out this blog: <a href="http:&#x2F;&#x2F;toddwschneider.com&#x2F;posts&#x2F;analyzing-1-1-billion-nyc-taxi-and-uber-trips-with-a-vengeance&#x2F;" rel="nofollow">http:&#x2F;&#x2F;toddwschneider.com&#x2F;posts&#x2F;analyzing-1-1-billion-nyc-ta...</a>

Really interesting article but I wish there was more data on the speed&#x2F;performance of the Redshift queries. It seems to cover everything but the actual performance metrics!

I&#x27;ve been curious whether this dataset could be exploited to invade privacy, e.g. by targeting rides to&#x2F;from from a sensitive address (medical-related, a strip club). Or by cross-checking it with other data, like a private detective comparing a pick-up recorded on a security camera and looking up where they went to in this database. I guess this makes it easier to find out.

really wish the AWS tutorials were this clean and a smiling photo of the author on the left menu and it gives a super human feel and it was easier to understand for me.