#abuzafor on behalf of Abu Zafor Khairuzzaman

I have written a python script that do the above task. The script first read configuraion from a YML file, export the SQL server data to a text file using BCP command, compressed the text file, upload the compressed file to S3, truncate the redshift table and finally execute a copy command to load the data to redshift from that file. | Tips & Tricks: Redshift: Upload Data to Redshift from SQL Server using Python Script | Tips & Tricks: Redshift: Upload Data to Redshift from SQL Server using Python Script |

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.