Explo
Search…
Connecting to your database or data warehouse
How to connect to your datasource

Connecting to different data sources

In order to connect to your database, you’ll need to gather some information about the database you want to use.
Here’s what you’ll need:
  • The hostname of the server where your database lives
  • The port the database server uses
  • The database name
  • The username you use for the database
  • The password you use for the database
If you don’t have this information handy, the person responsible for administering the database should have it.
You may need to whitelist our Explo IP's54.211.43.19, 52.55.98.121, 3.214.169.94,and54.156.141.148

Bigquery

Create a Bigquery service user:
  1. 1.
    In the Cloud Console, go to the Create service account key page.
  2. 2.
    From the Service account list, select New service account.
  3. 3.
    In the Service account name field, enter a name.
  4. 4.
    From the Role list, add the following roles
    1. 1.
      BigQuery Job User
    2. 2.
      BigQuery Data Viewer
    3. 3.
      BigQuery Metadata Viewer
  5. 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

If your database is behind a firewall, you will have to whitelist the following IPs 54.211.43.19, 52.55.98.121, 3.214.169.94, and 54.156.141.148
Please reach out to the Explo team at [email protected] if you need to connect via SSH tunnel or have other constraints.
Last modified 4d ago