Tag Archives for: "Amazon Redshift"

Wish to Become the #1 Shopping App? Use Treasure Data

The #1 shopping app on iOS and Android in the US is not Amazon. It's Wish.com. How did this startup founded in 2011 become the leading mobile e-commerce platform in North America and Europe? Using data an...

Redshift v. BigQuery: Similarities, Differences and the Serverless Future?

In broad strokes, both BigQuery and Redshift are cloud data warehousing services. Honestly, the similarities are greater than the differences, and if you are looking to graduate from MySQL/PostgreSQL/SQL Server for analytics or moving away from expensive perpetual license MPP databases, you can't re...

Mixpanel Doesn’t Like SQL

A couple of weeks ago, Mixpanel released JavaScript Query Language (JQL) as a new way of analyzing event data inside Mixpanel. It's clear that the Mixpanel team has realized that giving non-clunky access to raw event data emp...

October 8, 2015

Redshift is 400x Bigger than MySQL Yet MySQL is More Popular

The Amazon Redshift COPY Command Guide is now available! There are good reasons for the hype around Amazon Redshift. Redshift is blazing fast and not that much more expensive than MySQL or PostgreSQL, the traditional mainstay of data engineers. But is Amazon Redshift really becoming predominant i...

October 7, 2015

Treasure Data brings you: The Amazon Redshift COPY command cheatsheet

Although it's getting easier, ramping up on the COPY command to import tables into Redshift can become very tricky and error-prone. Following the accordion-like hyperlinked Redshift documentation to get a complete command isn't exactly straighforward, either. Treasure Data got in on the act (we...

October 6, 2015

AWS, SFDC and Marketo Data Connectors Released, Data Tanks in Beta for Broader BI Connectivity

This year's AWS re:Invent brings many new announcements and features from Treasure Data. Specifically, we released AWS Data Connectors (S3 and Redshift) and SaaS Data Connectors (Marketo and Salesforce) for general availability and Data Tanks for private beta. Also, the new workflow management featu...

September 24, 2015

Data loading into Amazon Redshift simplified: The Podcast, part 2

You can hear the whole podcast at this link. As we saw in Part 1 of this series, there are at least two sides to the development of any software feature; one is the perspective of the business person who requires the feature and then other is that of the developer who must create and maintain i...

September 17, 2015

Move your data – from MySQL to Amazon Redshift (in less time than it takes to ignore an index!)

Redshift, as you may already know, is quickly gaining broad acceptance, especially among consumers of free software like MySQL and PostgreSQL, for its "pay as you go" pricing model. However, the same pricing model can still make it a very expensive one. Not all queries need to be done against t...

September 3, 2015

Plug and Play Migration from Postgres to Redshift: One Billion Rows at a Time!

Redshift is a popular cloud data warehousing service by Amazon. Redshift brings the power of Massively Parallel Processing (MPP) databases --powerful but expensive software once reserved for IT departments with deep pockets, often in the order of millions of dollars per year-- to pretty much any com...

September 1, 2015

Data loading into Amazon Redshift simplified: The Podcast, part 1

You can hear the whole podcast at this link. There are two sides to everything, and in the case of software feature development, always at least two stories to be told: that of the business person who requires the feature, and the developer who creates and maintains it. Treasure Data has add...

1