Skip to content

Latest commit

 

History

History
18 lines (13 loc) · 1.28 KB

README.md

File metadata and controls

18 lines (13 loc) · 1.28 KB

northwind-amazon-redshift

Repo for loading Northwind sample data to the Amazon Redshift.

This repo contains:

  • Scripts to create tables in Northwind sample database (create-northwind-tables.sql)
  • Scripts to load data in the tables in Northwind sample database (load-northwind-table-*.sql)
  • Data in csv format for the tables in Northwind sample database (data/*.csv)

create-northwind-tables.sql

The scripts are adapted from Microsoft SQL Server samples repo and modified for supported datatypes for amazon redshift.

Renamed the tables & columns to follow the snake case (Ex: customer_demographics) better alinged with Amazon Redshift naming conventions instead of the pascal case (Ex: CustomerDemographics) used by Microsoft SQL Server.

load-northwind-table-*.sql

The scripts are adapted from Microsoft SQL Server samples repo and modified for Amazon Redshift.

data/*.csv

The data is provided in csv format which can easily be loaded to an S3 bucket and then loaded to Amazon Redshift.