Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Collecting or Uploading Statistics for the AWS Schema Conversion Tool

To optimize how the AWS Schema Conversion Tool (AWS SCT) converts your data warehouse schema, you can provide statistics from your source database that the tool can use. You can either collect statistics directly from the database, or upload an existing statistics file.

To provide and review statistics

  1. Connect to your source database. For more information, see Connecting to Your Source Database.

  2. Choose a schema object from the left panel of your project, and open the context (right-click) menu for the object. Choose Collect Statistics or Upload Statistics as shown following.

    
                        Context menu with collect statistics
  3. Choose a schema object from the left panel of your project, and then choose the Statistics tab. You can review the statistics for the object.

    
                        Statistics tab

    Later, when you review the suggested keys, if you are not satisfied with the results, you can collect additional statistics and repeat this procedure. For more information, see Managing and Customizing Keys in the AWS Schema Conversion Tool.

Related Topics

On this page: