Connecting to your database or data warehouse

How to connect to your datasource

Connecting to different data sources

Bigquery

Create a Bigquery service user:

  1. In the Cloud Console, go to the Create service account key page.

  2. From the Service account list, select New service account.

  3. In the Service account name field, enter a name.

  4. From the Role list, select BigQuery Job User.

  5. Click Create. A JSON file that contains your key downloads to your computer.

The Role field affects which resources your service account can access in your project. You can revoke these roles or grant additional roles later. For more information, see Granting, changing, and revoking access to resources.

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.

Redshift

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.

Secure connections

You may need to whitelist our Explo IP's 52.5.38.201 and 52.7.247.138

If you need to connect via SSH tunnel or have other contraints, please reach out to the Explo team at [email protected]