ContextQMD
Back to Aws Doc Sdk Examples

Amazon Redshift code examples for the SDK for Python

python/example_code/redshift/README.md

latest3.7 KB
Original Source

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.

<!--custom.overview.start--> <!--custom.overview.end-->

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.
<!--custom.important.start--> <!--custom.important.end-->

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
<!--custom.prerequisites.start--> <!--custom.prerequisites.end-->

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.

<!--custom.examples.start--> <!--custom.examples.end-->

Run the examples

Instructions

<!--custom.instructions.start--> <!--custom.instructions.end-->

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.
<!--custom.basic_prereqs.redshift_Scenario.start--> <!--custom.basic_prereqs.redshift_Scenario.end-->

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

python redshift_scenario.py
<!--custom.basics.redshift_Scenario.start--> <!--custom.basics.redshift_Scenario.end-->

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.

<!--custom.tests.start--> <!--custom.tests.end-->

Additional resources

<!--custom.resources.start--> <!--custom.resources.end-->

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

SPDX-License-Identifier: Apache-2.0