Amazon Web Services

Parsons provides utility functions and/or connectors for three different AWS services.

• Lambda
  • Overview
  • Quickstart
  • API
    • distribute_task()
    • event_command()
• Redshift
  • Overview
  • Quickstart
    • Core API
      • Redshift
        • Redshift.connection()
        • Redshift.query()
        • Redshift.query_with_connection()
        • Redshift.copy_s3()
        • Redshift.copy()
        • Redshift.unload()
        • Redshift.drop_and_unload()
        • Redshift.generate_manifest()
        • Redshift.upsert()
        • Redshift.alter_varchar_column_widths()
        • Redshift.alter_table_column_type()
        • Redshift.combine_schema_and_table_name()
        • Redshift.create_schema_with_permissions()
        • Redshift.create_table()
        • Redshift.detect_data_type()
        • Redshift.duplicate_table()
        • Redshift.format_column()
        • Redshift.format_columns()
        • Redshift.generate_alchemy_url()
        • Redshift.generate_engine()
        • Redshift.get_bigger_int()
        • Redshift.get_columns()
        • Redshift.get_columns_list()
        • Redshift.get_max_value()
        • Redshift.get_object_type()
        • Redshift.get_queries()
        • Redshift.get_row_count()
        • Redshift.get_table_definition()
        • Redshift.get_table_definitions()
        • Redshift.get_table_object()
        • Redshift.get_table_stats()
        • Redshift.get_tables()
        • Redshift.get_view_definition()
        • Redshift.get_view_definitions()
        • Redshift.get_views()
        • Redshift.grant_schema_permissions()
        • Redshift.is_table()
        • Redshift.is_valid_sql_num()
        • Redshift.is_view()
        • Redshift.move_table()
        • Redshift.populate_table_from_query()
        • Redshift.rename_table()
        • Redshift.split_full_table_name()
        • Redshift.split_table_name()
        • Redshift.table_exists()
        • Redshift.union_tables()
    • Table and View API
      • RedshiftTableUtilities
        • RedshiftTableUtilities.table_exists()
        • RedshiftTableUtilities.get_row_count()
        • RedshiftTableUtilities.rename_table()
        • RedshiftTableUtilities.move_table()
        • RedshiftTableUtilities.populate_table_from_query()
        • RedshiftTableUtilities.duplicate_table()
        • RedshiftTableUtilities.union_tables()
        • RedshiftTableUtilities.get_tables()
        • RedshiftTableUtilities.get_table_stats()
        • RedshiftTableUtilities.get_columns()
        • RedshiftTableUtilities.get_columns_list()
        • RedshiftTableUtilities.get_views()
        • RedshiftTableUtilities.get_queries()
        • RedshiftTableUtilities.get_max_value()
        • RedshiftTableUtilities.get_object_type()
        • RedshiftTableUtilities.is_view()
        • RedshiftTableUtilities.is_table()
        • RedshiftTableUtilities.get_table_definition()
        • RedshiftTableUtilities.get_table_definitions()
        • RedshiftTableUtilities.get_view_definition()
        • RedshiftTableUtilities.get_view_definitions()
        • RedshiftTableUtilities.split_full_table_name()
        • RedshiftTableUtilities.combine_schema_and_table_name()
    • Schema API
      • RedshiftSchema
        • RedshiftSchema.create_schema_with_permissions()
        • RedshiftSchema.grant_schema_permissions()
• S3
  • Overview
  • Quickstart
    • Temporary Credentials
  • API
    • S3
      • S3.s3
      • S3.client
      • S3.list_buckets()
      • S3.bucket_exists()
      • S3.list_keys()
      • S3.key_exists()
      • S3.create_bucket()
      • S3.put_file()
      • S3.remove_file()
      • S3.get_file()
      • S3.get_url()
      • S3.transfer_bucket()
      • S3.get_buckets_with_subname()

• Lambda: AWS’s serverless computing platform

• S3: AWS’s object storage service

• Redshift: AWS’s data warehousing service, with two additional classes providing utility functions.

• Table and View API: Methods for managing tables and views

• Schema API: Methods for managing schema

See the documentation for each service for more details.