Skip to content

khairuzzaman/ImportDataToRedshift

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
.idea
.idea
 
 
AWSServices
AWSServices
 
 
DataContexts
DataContexts
 
 
Util
Util
 
 
__pycache__
__pycache__
 
 
ImportDataToRedshift.py
ImportDataToRedshift.py
 
 
README.md
README.md
 
 
config.yml
config.yml
 
 
setup.py
setup.py
 
 

Repository files navigation

Python Script for Upload Data to Redshift from SQL Server

The purpose of this script is to automate the manual task of uploading data to Redshift cluster from SQL Server. It works as like

1. Export data from SQL Server to a text file using BCP command.
2. Compressed the text file to gzip using gzip module.
3. Upload the compressed file to s3 bucket.
4. Truncate the target table of Redshift.
5. Load the data from the compressed file using the copy command.

About

Python Script for Export Data from SQL Server to Redshift

Resources

Readme
Activity

Stars

5 stars

Watchers

2 watching

Forks

2 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages