Learn how to load data into redshift using simple command line. Read more.. http://zappysys.com/products/zappyshell/amazon-redshift-command-line-tools/ <br /> <br />Command line for Amazon Redshift <br /> <br />◾Import data to AWS Redshift database from files or relational source (e.g. MySQL, Oracle, SQL Server) <br />◾Import huge amount of data (millions of rows) in few minutes with parallel load techniques <br />◾Load local flat files to Redshift in just single line command (option to compress data files to *.gz to speed up transfer) <br />◾Support for Client side encryption using AES 256 Key <br />◾Load data from any data source (ODBC,ADO.net or OLEDB) using sql query <br />◾Import compressed data files (*.gz) to redshift <br />◾Archive files, error reporting, file splitting, many other features <br /> <br /> <br />====================== <br />Examples: <br />====================== <br /> <br />############################################## <br />#below command will import data from any relation source (e.g. SQL Server) into redshift DB <br />############################################## <br />import Db <br /> --source-driver ADONET_MSSQL <br /> --source-query "SELECT top 10000 ROW_NUMBER()Over(order by a.CustomerID) Id , a.*,b.*,c.OrderID ,c.OrderDate,c.Freight FROM customers a,products b,orders c" <br /> --maxrows-perfile 1000 <br /> --source-stagepath "c:\redshift\stage" <br /> --target-table "customerdata" <br /> --target-stagepath "bw-rstest/cmdstage" <br /> --target-truncate <br /> --logfile "c:\redshift\log.txt" <br /> --region us-east-1 <br /> --accesskey "AKIA*****************" <br /> --secretkey "lPi+XQ************************" <br /> --source-connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;" <br /> --target-connstr "Host=mytestcluster-1.csu********.us-east-1.redshift.amazonaws.com;Port=5439;Database=dev;UserName=masteruser;Password=*********;EnableSsl=true;Timeout=30;CommandTimeout=3600;" <br /> <br />############################################## <br />#below command will import local files in redshift DB <br />############################################## <br />import file <br /> --source-path "c:\data\files\*.part.csv" <br /> --source-stagepath "c:\redshift\stage" <br /> --target-table "customerdata" <br /> --target-stagepath "bw-rstest/cmdstage" <br /> --target-truncate <br /> --logfile "c:\redshift\log.txt" <br /> --region us-east-1 <br /> --accesskey "AKIA*****************" <br /> --secretkey "lPi+XQ************************" <br /> --source-connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;" <br /> --target-connstr "Host=mytestcluster-1.csu********.us-east-1.redshift.amazonaws.com;Port=5439;Database=dev;UserName=masteruser;Password=*********;EnableSsl=true;Timeout=30;CommandTimeout=3600;"
