Book Image

Getting Started with Amazon Redshift

By : Stefan Bauer
Book Image

Getting Started with Amazon Redshift

By: Stefan Bauer

Overview of this book

<p>Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service. It provides an excellent approach to analyzing all your data using your existing business intelligence tools.</p> <p>Getting Started with Amazon Redshift is an easy-to-read, descriptive guide that breaks down the complex topics of data warehousing and Amazon Redshift. You will learn the fundamentals of Redshift technology and how to implement your own Redshift cluster, through practical, real-world examples. This exciting new technology is a powerful tool in your arsenal of data management and this book is a must-have to implement and manage your next enterprise Data Warehouse.</p> <p>Packed with detailed descriptions, diagrams, and explanations, Getting Started with Amazon Redshift will bring you along, regardless of your current level of understanding, to a point where you will feel comfortable with running your own Redshift cluster. The author's own experiences will give you an understanding of what you will need to consider when working with your own data. You will also learn about how compression has been implemented and what that means relative to a column store database structure. As you progress, you will gain an understanding of monitoring techniques, performance considerations, and what it will take to successfully run your Amazon Redshift cluster on a day-to-day basis. There truly is something in this book for everyone who is interested in learning about this technology.</p>
Table of Contents (14 chapters)

SQL commands


The SQL commands listed here are either different from standard SQL implementations due to Redshift needs or are otherwise important to highlight. This is not a SQL reference; most SQL that you will run in Redshift will function as you would expect it to normally.

  • ALTER: This command is at the table level only; there are no alter column commands (see Chapter 5, Querying Data).

  • ANALYZE: The command used to capture statistical information about a table for use by the query planner (see Chapter 4, Managing Your Data).

  • COPY: The following screenshot shows the syntax of this command (see Chapter 3, Loading Your Data to Redshift):

  • CREATE TABLE: Here is a command reference for this SQL statement (see Chapter 3, Loading Your Data to Redshift):

  • GRANT: Used to allow specific permissions to an object or schema. The syntax is GRANT [permission] on [object] to [username].

  • CREATE GROUP: Used to associate users to a logical grouping. The syntax is CREATE GROUP group_name [ [with] [USER username(s)]].

  • CREATE SCHEMA: Used to isolate objects. The syntax is CREATE SCHEMA schema_name [ AUTHORIAZATION username] [schema_element(s)].

  • VACUUM: A process to physically reorganize tables after load activity (see Chapter 4, Managing Your Data).