Can Apache Drill Connect to Amazon RedShift?
Yes, just use Example-Postgres-Configuration
And then use the web gui to add storage:
{
"type" : "jdbc",
"driver" : "org.postgresql.Driver",
"url" : "jdbc:postgresql://URL:5439/DB_NAME_HERE",
"username" : "user",
"password" : "password",
"enabled" : true
}
source to share
I was unable to get an example from @pavel to work. I'm pretty sure it has to do with the name of the driver, and what specific driver is loaded and installed.
However, I was able to successfully connect to AWS Redshift by following the steps below.
Go to the folder that you downloaded to:
cd ~/Downloads/apache-drill-1.11.0
download the required jdbc drivers from AWS at Download Amazon Redshift JDBC Driver
save jar files to ~ / Downloads / apache-drill-1.11.0 / jars / 3rdparty folder
start drill using:
./bin/drill-embedded
Go to http: // localhost: 8047 / storage to configure the new datasource as a plugin.
Create a new storage plugin and name the data source appropriately. for my test I called it redshift.
Once you named the source as "redshift" paste in the correct config
{
"type" : "jdbc",
"driver" : "com.amazon.redshift.jdbc42.Driver",
"url" : "jdbc:redshift://redshiftserver.mydomain.net:5439/databaseName?ssl=true&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory",
"username" : "username",
"password" : "password",
"enabled" : true
}
next test connection to server using following request
select * from redshift.autonation.information_schema.columns
source to share