I want to import Data from AWS S3 Bucket into MySQL Database using JDBC or ODBC Connectivity. I want to know how it's done? I tried using AWS Lambda but I need to do it only using JDBC or ODBC connectivity
CodePudding user response：
This can be done using an AWS Lambda function and using the Java Lambda runtime. Use the AWS S3 Java API to read the data from an Amazon S3 bucket from within the Lambda function. Also use the Java JDBC API to insert the data into the MySQL database.
CodePudding user response：
- pyodbc is a popular odbc module if you are interested in using python.
- mysql connectors are popular (also in python)
- AUrora mysql also supports rds-data api. This means you can simply use boto3 to batch load your data into mysql....