More about Periscope Data
▾
Free Trial
Product
Periscope Pro
Periscope Express
Compare Solutions
Features
Data Discovery
Embedded Analytics
Partners & Integrations
Security
Customers
Overview
Case Studies
Tell Us Your Story
Resources
Overview
Blog
Guides
Webinars
Community
Docs
Company
Homepage
About Us
Leadership
Careers
News
Contact Us
Thank you for subscribing!
.
Periscope Data
The High-Performance SQL Blog
Advanced SQL
Analysis
Statistics
Company
Databases
Product
SQL 101
Tips and Tricks
Periscope Data
The High-Performance SQL Blog
Advanced SQL
Analysis
Statistics
Company
Databases
Product
SQL 101
Tips and Tricks
Thank you for subscribing!
About Periscope Data
Contact Us
Free Trial
Databases
“This is My Architecture”: Behind the Scenes of Periscope Data’s Architecture
January 2, 2018
Amazon Redshift’s Hardware Upgrade Improves Query Speed by up to 5x
October 17, 2017
Using Python to Write a Create Table Statement and Load a CSV into Redshift
July 12, 2017
How to Get Started With AWS Spectrum in Minutes
June 6, 2017
How Joins Work
February 1, 2017
Data Warehouse Management: Redshift, Bigquery, and Snowflake
October 21, 2016
Converting MySQL Syntax and Functions into Redshift
May 26, 2016
Concatenating Rows in Redshift, Postgres, & MySQL
November 12, 2015
Building the Periscope Data Cache with Amazon Redshift
October 22, 2015
Understanding Distributed Analytics Databases, Part 2 — Data Distribution
October 8, 2015
Understanding Distributed Analytics Databases, Part 1: Query Strategies
September 30, 2015
Connecting to a Redshift Cluster with a Private IP
August 27, 2015
Setting up Your Redshift Cluster
August 20, 2015
How to ETL Data into and out of Amazon Redshift
July 30, 2015
Explain and Other Tools for Query Optimization
July 9, 2015
4 Reasons Not To Use MySQL For Analysis
June 18, 2015
10 Rules for a Better SQL Schema
June 3, 2015
Optimizing Query Management on Redshift
May 27, 2015
Helpful Redshift Admin Queries
April 30, 2015
The Lazy Analyst's Guide To Postgres JSON
March 12, 2015
Exact Row Counts for All Tables in MySQL and Postgres
March 5, 2015
$3000 Data Warehouse — Redshift vs. Postgres
February 26, 2015
Importing Data into Redshift from MySQL and Postgres
February 19, 2015
Counting Comma-Delimited Values in Postgres, MySQL, Amazon Redshift and MS SQL Server.
February 5, 2015
Demystifying Redshift — What's Up with My Disks?
January 22, 2015
Redshift Maintenance 101
January 15, 2015
Changing Dist and Sort Keys on Giant Tables in Redshift
December 24, 2014
Cross-Database Joins
November 17, 2014
Optimizing Your psql
October 23, 2014
Hashing Tables to Ensure Consistency in Postgres, Redshift and MySQL
June 3, 2014
Faster Redshift Queries with Materialized Views — Lifetime Daily ARPU
May 15, 2014
Count Distinct Compared on Top 4 SQL Databases
May 1, 2014
Try Periscope Data for Free
Free Trial
