Upcoming AWS re:Invent Talk: Scaling Redshift to Ingest 1 Billion Rows per Day

Please join 47Lining SVP Ops, Bill Weiner for an AWS re:Invent session to learn how to scale Redshift to ingest 1 Billion rows per day. When: November 29, 2016 Where: AWS re:Invent, Las Vegas Registration:https://www.portal.reinvent.awsevents.com/connect/sessionDetail.ww?SESSION_ID=11761 In this session, you will learn about: Effective patterns for ingest, de-dup, aggregate, vacuum into Redshift How to balance rapid ingest and query speeds Strategies for data partitioning / orchestration…

Upcoming AWS re:Invent Talk: Leveraging Amazon Machine Learning, Amazon Redshift and Amazon S3 Data Lake for Strategic Advantage in Real Estate

Please join 47Lining CEO, Mick Bass, and The Howard Hughes Corporation SVP, Daryan Dehghanpisheh, for an AWS re:Invent Machine Learning Mini-Con session – Leveraging Amazon Machine Learning, Amazon Redshift and Amazon S3 Data Lake for Strategic Advantage in Real Estate When: November 30, 2016 Where: AWS re:Invent Machine Learning Mini-Con, Las Vegas Presented by: 47Lining, The Howard Hughes Corporation Registration: https://www.portal.reinvent.awsevents.com/connect/sessionDetail.ww?SESSION_ID=8520 In this session, you…

Improving Redshift Query Performance by Reducing Query Steps

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze an organization’s data using existing business intelligence tools. In our first and second blog posts in this series, we pointed out that our experience assisting clients with slow Redshift queries points to three main contributing factors: ineffective zone maps, excessive network traffic and too many query steps.…

Upcoming Webinar: Redshift Jumpstart – PH Tech’s Move to Offer Data-as-a-Service

Please join 47Lining CEO, Mick Bass, and PH Tech VP Information Technology, Chad Casady, for a live webinar – Redshift Jumpstart – PH Tech’s Move to Offer Data-as-a-Service When: July 20, 2016, 10:00am PT Presented by: 47Lining, PH Tech Registration: http://www.47lining.apncampaigns.com/Redshift-Jumpstart-PH-Tech In this webinar, you will learn about: How to jumpstart your data warehousing and business intelligence workload using Amazon Redshift Design patterns for ingest,…

Improving Redshift Query Performance by Decreasing Network Traffic

In our last Redshift Whisperer blog post, Improving Redshift Query Performance Through Effective Use of Zone Maps, we described Amazon Redshift as a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze an organization’s data using existing business intelligence tools. Our experience assisting clients with slow Redshift queries has led us to the determination that most Redshift performance issues stem…

Improving Redshift Query Performance Through Effective Use of Zone Maps

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze an organization’s data using existing business intelligence tools. Redshift is fast. Very fast! … except when it’s not. Right out of the box, Redshift can search through vast amounts of data and provide complex analytic results in shockingly short query times. Then why do we spend significant…