mysqldatagripcsv-importamazon-aurora

CSV import to AWS Aurora MySQL(5.6) with DataGrip dropping connection

I'm trying to import a 100MB csv file into a database using DataGrip.

I have connection to the database and can run queries, but when I do the "Import data from file" action I keep getting this error.

enter image description here

You can see in the screenshot that it imports > 31 000 rows before dropping the connection.

Driver information

enter image description here

Any ideas on what could be reason?

I wrote a script that reads the csv file and inserts each record line by line, but it's slow as hell and I'd like to solve this.

Solution

  • Seems to be related to DNS cache. Try to switch to MariaDB driver and use jdbc:mariadb:aurora// prefix in jdbc url

    Full template:jdbc:mariadb:aurora://[clusterInstanceEndPoint[:port]]/[database][?<key1>=<value1>[&<key2>=<value2>]…])

    Based on AWS Aurora user guide and Aurora connection management guide.