Learn how to load data into redshift using simple command line. Read more.. 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 ADONETMSSQL br --source-query "SELECT top 10000 ROWNUMBER()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-rstestcmdstage" 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-rstestcmdstage" 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.