Accessing a Redshift cluster using JDBC to query data
Redshift has many connection options depending on the use case and downstream requirements. In this recipe, we will focus on how to connect Glue to Redshift using JDBC. The main benefits of using a JDBC connection are the following:
- You can connect to Redshift using a wide variety of tools
- Depending on your use case, you can access Redshift data within your ETL job without going through the Glue crawler, which will help you save on cost
Getting ready
To connect with Amazon Redshift through JDBC, you’ll need the following:
- AWS Glue notebook: Make sure you know how to use Glue notebooks.
- Redshift cluster: You should have a working Redshift cluster with the necessary data. If you don’t have one, create it before proceeding.
- Access credentials: You should have access credentials to your cluster.
- Configure security group and VPC endpoint: You should complete the setup of relevant...
