Skip to content

Files

Latest commit

scmacdonscmacdon
Feb 20, 2025
c32ed3c · Feb 20, 2025

History

History

redshift

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
test
test
 
 
README.md
README.md
 
 
hello.py
hello.py
 
 
redshift.py
redshift.py
 
 
redshift_data.py
redshift_data.py
 
 
redshift_scenario.py
redshift_scenario.py
 
 
requirements.txt
requirements.txt
 
 

README.md

Amazon Redshift code examples for the SDK for Python

Overview

Shows how to use the AWS SDK for Python (Boto3) to work with Amazon Redshift.

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools.

⚠ Important

  • Running this code might result in charges to your AWS account. For more details, see AWS Pricing and Free Tier.
  • Running the tests might result in charges to your AWS account.
  • We recommend that you grant your code least privilege. At most, grant only the minimum permissions required to perform the task. For more information, see Grant least privilege.
  • This code is not tested in every AWS Region. For more information, see AWS Regional Services.

Code examples

Prerequisites

For prerequisites, see the README in the python folder.

Install the packages required by these examples by running the following in a virtual environment:

python -m pip install -r requirements.txt

Get started

Basics

Code examples that show you how to perform the essential operations within a service.

Single actions

Code excerpts that show you how to call individual service functions.

Run the examples

Instructions

Hello Amazon Redshift

This example shows you how to get started using Amazon Redshift.

python hello.py

Learn the basics

This example shows you how to do the following:

  • Create a Redshift cluster.
  • List databases in the cluster.
  • Create a table named Movies.
  • Populate the Movies table.
  • Query the Movies table by year.
  • Modify the Redshift cluster.
  • Delete the Amazon Redshift cluster.

Start the example by running the following at a command prompt:

python redshift_scenario.py

Tests

⚠ Running tests might result in charges to your AWS account.

To find instructions for running these tests, see the README in the python folder.

Additional resources

Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.

SPDX-License-Identifier: Apache-2.0