Skip to main content

Lab: Data Loading into Redshift

Load with COPY command​

  1. Create 8 Tables based on TPCH data model in Redshift (DDL)
  2. Load data into these tables from S3 bucket using COPY command (DML)
  3. See the effect of different VACUUM commands

Load using Python​

  1. Connect to Redshift and Read data using Psycopg2 library
  2. Taxi Data Process and Save to Redshift using AWS Wrangler library
Last updated on by sparsh