<div>
Drop a file in a S3 bucket and import that file to Redshift:<br />
<br />
- <a href="https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-loading-take-loading-data-tutorial.html" rel="ugc">Take the Loading Data Tutorial</a>.<br />
- <a href="https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-use-multiple-files.html" rel="ugc">Split Your Load Data into Multiple Files</a>.
</div>


Drop a file in a S3 bucket and import that file to Redshift:

- Take the Loading Data Tutorial [https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-loading-take-loading-data-tutorial.html].
- Split Your Load Data into Multiple Files [https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-use-multiple-files.html].

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
&nbsp;I'm writing a C# program which insert huge data to Amazon Redshift table (one table).<br />
I've wrote a loop over the &nbsp;DataTable then insert a row by row to the table, This solution is OK but takesa lot of time if we talking about 1M rows.<br />
The DataTable structure &amp;&nbsp;the Redshift table are similar <br />
<br />
Can you please help bulk insert the table to Redshift ?<br />
<br />
Thanks,<br />
&nbsp;Jamil
</div>
</div>


Hello Experts,

 I'm writing a C# program which insert huge data to Amazon Redshift table (one table).
I've wrote a loop over the  DataTable then insert a row by row to the table, This solution is OK but takesa lot of time if we talking about 1M rows.
The DataTable structure & the Redshift table are similar 

Can you please help bulk insert the table to Redshift ?

Thanks,
 Jamil

Amazon Redshift Bulk Insert from C#

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Amazon Web Services (AWS), is a collection of remote computing services, also called web services, that make up a cloud-computing platform  operated from 11 geographical regions across the world. The most central and well-known of these services include Amazon Elastic Compute Cloud, also known as "EC2", and Amazon Simple Storage Service, also known as "S3". Other services include Elastic MapReduce (EMR), Route 53 (a DNS web service),  provides a highly available and scalable Domain Name System (DNS) web service, Virtual Private Cloud (VPC), storage, database, deployment and application services.