CODEWITHSUNDEEP
c#mysqlamazon-s3
aka baka
aka baka

Reputation: 223

How to load csv file from s3 bucket using C# and MySql?

I want to load CSV file to MySql database table using a file from s3 bucket. I am able to load the file from the local drive using the following code

                using (MySqlConnection myConn = new MySqlConnection("Server = localhost; Database = aaaa; Uid = bbbb; Pwd = ccc"))
                {

                MySqlBulkLoader loader = new MySqlBulkLoader(myConn);
                loader.TableName = "mytable";
                loader.FieldTerminator = "|";
                loader.LineTerminator = "\n";
                loader.NumberOfLinesToSkip = 2;
                loader.FileName = "c:\file1.csv";

                myConn.Open();
                int insertCount = bulkLoader.Load();
                myConn.Close();

            }

Can you pleas provide some example to load the csv file from s3 bucket? Thank you.

Upvotes: 0

Views: 1046

Answers (1)

Rakesh Thakre
Rakesh Thakre

Reputation: 40

LOAD DATA FROM S3 's3://db-bucket-name/folder-name/test.csv' INTO TABLE table-name FIELDS TERMINATED BY ',' ENCLOSED BY '"+'"'+"' LINES TERMINATED BY '\r\n';

Upvotes: 1

Related Questions