In Explo, select Bigquery, enter the project id, and paste the JSON key into the field to connect to that service account.
You can find your Redshift cluster details via the AWS console. The Endpoint section gives you the hostname and port all in one. You'll need to get the database name and a username/password from whoever set up the Redshift cluster.
In Explo, select Redshift, and enter the credentials to connect. You may need to whitelist our IP addresses.
If your database is behind a firewall, you will have to whitelist the following IPs 22.214.171.124, 126.96.36.199, 188.8.131.52, and 184.108.40.206
Please reach out to the Explo team at [email protected] if you need to connect via SSH tunnel or have other constraints.