Are you a database developer? - Amazon Redshift

Are you a database developer?

If you are a first-time Amazon Redshift user, we recommend you read Amazon Redshift Serverless to learn how to get started.

If you are a database user, database designer, database developer, or database administrator, the following table will help you find what you're looking for.

If you want to... We recommend...

Learn about the internal architecture of the Amazon Redshift data warehouse.

The System and architecture overview gives a high-level overview of Amazon Redshift's internal architecture.

If you want a broader overview of the Amazon Redshift web service, go to the Amazon Redshift product detail page.

Create databases, tables, users, and other database objects.

Getting started using databases is a quick introduction to the basics of SQL development.

The Amazon Redshift SQL has the syntax and examples for Amazon Redshift SQL commands and functions and other SQL elements.

Amazon Redshift best practices for designing tables provides a summary of our recommendations for choosing sort keys, distribution keys, and compression encodings.

Learn how to design tables for optimum performance.

Working with automatic table optimization details considerations for applying compression to the data in table columns and choosing distribution and sort keys.

Load data.

Loading data explains the procedures for loading large datasets from Amazon DynamoDB tables or from flat files stored in Amazon S3 buckets.

Amazon Redshift best practices for loading data provides for tips for loading your data quickly and effectively.

Manage users, groups, and database security.

Managing database security covers database security topics.

Monitor and optimize system performance.

The System tables and views reference details system tables and views that you can query for the status of the database and monitor queries and processes.

Also consult the Amazon Redshift Management Guide to learn how to use the AWS Management Console to check the system health, monitor metrics, and back up and restore clusters.

Analyze and report information from very large datasets.

Many popular software vendors are certifying Amazon Redshift with their offerings to enable you to continue to use the tools you use today. For more information, see the Amazon Redshift partner page.

The SQL reference has all the details for the SQL expressions, commands, and functions Amazon Redshift supports.

Interact with Amazon Redshift resources and tables.

See the Amazon Redshift Serverless API guide, the Amazon Redshift API guide, and the Amazon Redshift Data API guide to learn more about how you can programmatically interact with resources and run operations.

Follow a tutorial to become more familiar with Amazon Redshift.

Follow a tutorial in Tutorials for Amazon Redshift to learn more about Amazon Redshift features.