Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

The AWS Schema Conversion Tool Extension Pack and Python Libraries for Data Warehouses

When you convert your data warehouse schema, the AWS Schema Conversion Tool (AWS SCT) adds an additional schema to your target DB instance. This schema implements system functions of the source database that are required when writing your converted schema to your target DB instance. The schema is called the extension pack schema.

If you are converting a transactional database, instead see The AWS Schema Conversion Tool Extension Pack and AWS Services for Databases.

The extension pack schema is named according to your source database as follows:

  • Greenplum: AWS_GREENPLUM_EXT

  • Microsoft SQL Server: AWS_SQLSERVER_EXT

  • Netezza: AWS_NETEZZA_EXT

  • Oracle: AWS_ORACLE_EXT

  • Teradata: AWS_TERADATA_EXT

  • Vertica: AWS_VERTICA_EXT

In two cases, you might want to install the extension pack manually:

  • You accidentally delete the extension pack database schema from your target database.

  • You want to upload custom Python libraries to emulate database functionality.

Using AWS Services to Upload Custom Python Libraries

In some cases, source database features can't be converted to equivalent Amazon Redshift features. AWS SCT contains a custom Python library that emulates some source database functionality on Amazon Redshift.

The AWS SCT extension pack wizard helps you install the custom Python library.

Before You Begin

Almost all work you do with AWS SCT starts with the following three steps:

  1. Create an AWS SCT project.

  2. Connect to your source database.

  3. Connect to your target database.

If you have not created an AWS SCT project yet, see Getting Started with the AWS Schema Conversion Tool.

Before you install the extension pack, you need to convert your database schema. For more information, see Converting Data Warehouse Schema to Amazon Redshift by Using the AWS Schema Conversion Tool.

Applying the Extension Pack

Use the following procedure to apply the extension pack.

To apply the extension pack

  1. In the AWS Schema Conversion Tool, in the target database tree, open the context (right-click) menu, and choose Apply Extension Pack.

    
                        Apply Extension Pack context menu

    The extension pack wizard appears.

  2. Read the Welcome page, and then choose Next.

  3. On the AWS Services Settings page, do the following:

    • If you are reinstalling the extension pack database schema only, choose Skip this step for now, and then choose Next.

    • If you are uploading the Python library, provide the credentials to connect to your AWS account. You can use your AWS Command Line Interface (AWS CLI) credentials if you have the AWS CLI installed. You can also use credentials that you previously stored in a profile in the global application settings and associated with the project. If necessary, choose Navigate to Project Settings to associate a different profile with the project. If necessary, choose Global Settings to create a new profile. For more information, see Storing AWS Profiles in the AWS Schema Conversion Tool.

  4. On the Python Library Upload page, do the following:

    • If you are reinstalling the extension pack database schema only, choose Skip this step for now, and then choose Next.

    • If you are uploading the Python library, provide the Amazon S3 path, and then choose Upload Library to S3. When you are done, choose Next.

  5. On the Functions Emulation page, choose Create Extension Pack. Messages appear with the status of the extension pack operations. When you are done, choose Finish.

Related Topics