title: Fastest way to Import Data from AWS Redshift to BI Tool
body: <p>I have a table in AWS redshift running ra3.xlplus with 2 nodes which has 15 million rows. I am retrieving data on-premise at the office. I am trying to load that data into Memory in a BI tool. It takes a lot of time (12 minutes) to import that data over using a JDBC connection. Also tried on ODBC connection got same result.  I tried to spin up a EC2 with a 25 gigabit connection on AWS, but got the same results.</p>
  <p>For comparison loading that data in CSV format takes about 90 seconds.</p>
  <p>Are there any solutions as to speed up data transfer.</p>