Create a Bigquery service user:
In the Cloud Console, go to the Create service account key page.
From the Service account list, select New service account.
In the Service account name field, enter a name.
From the Role list, select BigQuery Job User.
Click Create. A JSON file that contains your key downloads to your computer.
Connect to Bigquery:
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.
You may need to whitelist our Explo IP's
If you need to connect via SSH tunnel or have other contraints, please reach out to the Explo team at [email protected]