Topics
July 12, 2017
Using Python to Write a Create Table Statement and Load a CSV into RedshiftFor wide tables, it can be a pain to write those long create table statements and load the data into Redshift. Here is some simple Python to get the job done using the 2017 Stack Overflow survey.
Read MoreJune 8, 2017
SQL Query Order of ExecutionThe SQL order of execution defines the order in which the clauses of a query are evaluated. Let's look at how your query SQL executes, and how you can use that knowledge to write faster SQL
Read MoreJune 6, 2017
How to Get Started With AWS Spectrum in MinutesAWS Redshift Spectrum is Amazon’s newest database technology, allowing exabyte scale data in S3 to be accessed through Redshift. This is not simply file access; Spectrum uses Redshift's brain, deploying workers by the thousands to order, join and aggregate your data before sending the minimum amount of data needed back to your Redshift cluster to finish your query. Learn how to get started!
Read MoreFebruary 1, 2017
How Joins WorkThe SQL join operation is one of the most powerful and commonly used SQL operations, but little attention is paid to how the internal SQL engine breaks down the tasks of join operations.
Read MoreOctober 21, 2016
Data Warehouse Management: Redshift, Bigquery, and SnowflakeIn our post comparing Redshift, BigQuery, and Snowflake on query performance and cost for interactive analytics, we looked at the trade-offs across different data warehouses from a performance perspective.
Read MoreOctober 20, 2016
Interactive Analytics: Redshift vs Snowflake vs BigQueryEvery day customers ask us what the best data warehouse technology is for handling the workload of their growing analytics department: they want to run queries at interactive, real-time speeds at a price-point that fits in their budget.
Read More