mapD connector to AWS redshift


#1

Short Q,

Does the SQL importer* works with aws redshift? Or the way to get redshift data would be to first dump the redshift tables into csv files in S3, and then load them into mapD?
*https://www.mapd.com/docs/latest/mapd-core-guide/loading-data/#sql-importer

if it doesn’t work with redshift, the list of importers would be mySQL, postgreSQL and SQL server? those are in the examples but wonder if someone has had luck with other DBs.


#2

Ok. good news folks! it works perfectly fine with AWS redshift so far.

java -cp $MAPD_PATH/bin/mapd-1.0-SNAPSHOT-jar-with-dependencies.jar:/home/ubuntu/RedshiftJDBC42-1.2.10.1009.jar com.mapd.utility.SQLImporter -t test3 -su <redshift_username> -sp <redshift_pass> -c "jdbc:redshift://<redshift_host>:5439/<db_name>" -ss "SELECT * FROM schema.mytable"

And one can download the latest redshift jdbc driver from here:
http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html

JDBC 4.2–compatible driver: https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC42-1.2.10.1009.jar. (The class name for this driver is com.amazon.redshift.jdbc42.Driver.)