Upsolver
Search…
Welcome to Upsolver
Getting Started
Start using Upsolver for free
Get started as a Upsolver user
Upsolver concepts
Upsolver Amazon AWS deployment guide
Tutorials and FAQ
Glossary
Troubleshooting
Connecting data sources
Amazon AWS data sources
Microsoft Azure data sources
Kafka data source
Google Cloud Storage data source
File upload data source
CDC data sources (Debezium)
JDBC data source
HDFS data source
Data source UI
Data source properties
Data outputs and data transformation
Data outputs
Data transformation
Guide for developers
Upsolver REST API
CI/CD on Upsolver
Administration
Connections
Amazon S3 connection
Amazon Kinesis connection
Amazon Redshift connection
Amazon Athena connection
Amazon S3 over SQS connection
Google Storage connection
Azure Blob storage connection
Snowflake connection
MySQL connection
Elasticsearch connection
HDFS connection
Qubole connection
PostgreSQL connection
Microsoft SQL Server connection
Spotinst Private VPC connection
Kafka connection
Clusters
Python UDF
Reference data
Workspaces
Monitoring
Security
Release notes
Change log
Support
Upsolver support portal
Powered By
GitBook
Amazon Redshift connection
This article provides a guide on how to create an Amazon Redshift connection in Upsolver.
Create an Amazon Redshift connection
1. Enter the
connection string
.
This can be found as the
JDBC URL
under your cluster's
General Information
or under
Properties
in the
Connection details
section.
It should be of the following format:
jdbc:redshift://CLUSTER_NAME.USER_WITH_REGION.redshift.amazonaws.com:PORT/DB_NAME
2. Enter the
username
for this Redshift database.
3. Enter the corresponding
password
.
4.
Name
this connection.
5. (Optional) Enter in the number of
concurrent connections
.
If you experience a
SocketTimeoutException
, it is likely a
Network and Security
issue. To fix this, you can:
1.
make your cluster
publicly accessible
under the
Properties
tab
2.
reconfigure the
inbound rules
for your cluster's VPC security group (allow all traffic from all sources)
For a more secure option, you can also choose to implement
VPC peering
.
Previous
Amazon Kinesis connection
Next
Amazon Athena connection
Last modified
1yr ago
Copy link