$ brew tap dpogorelov/homebrew-psqlodbc
$ brew install libiodbc
$ brew install psqlodbc --with-iodbc
Although I've been able to connect to Redshift with unixodbc using the psqlodbc driver from R, I wasn't able to from Julia. I've been able to connect successfully with iODBC.
iODBC doesn't seem to like using configured DSNs. I've had success connecting from R, Julia, and Python using ODBC.
In all situations I've had to connect using ODBC's SQLDriverConnect routine.
Pkg.add("ODBC")
using ODBC
ODBC.advancedconnect("Driver=/usr/local/lib/psqlodbcw.so;Database=data;Username=user;Password=pass;Server=foo.redshift.amazonaws.com;Port=5439;")
ODBC.query("SELECT * FROM information_schema.tables")install.packages("RODBC")
c <- odbcDriverConnect("Driver=/usr/local/lib/psqlodbcw.so;Database=data;Username=user;Password=pass;Server=foo.redshift.amazonaws.com;Port=5439;")
results <- sqlQuery(c, "SELECT * FROM information_schema.tables")