1. Database Setup
  2. Connecting to your database or data warehouse

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.

Some databases requires different sets of credentials in order for us to connect to them:

Postgres, MySQL, Redshift, Azure, Microsoft SQL Server, Clickhouse

  • 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’s,,,and54.156.141.148

IAM Authentication

Postgres and MySQL support AWS credential based authentication using AWS access keys. Make sure your created IAM user has the necessary privileges in your database to let Explo read your tables.

To create an IAM user, see here

Finding Redshift Credentials

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.


  • The project id

  • The JSON key for that service account

BigQuery Credentials

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, add the following roles

    1. BigQuery Job User
    2. BigQuery Data Viewer
    3. BigQuery Metadata Viewer
  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.

Secure connections

If your database is behind a firewall, you will have to whitelist the following IPs,,, and

To connect to your database via an SSH tunnel, you can provide us those credentials in the “Security” section of the connetion flow:

  • SSH Server Hostname

  • SSH Server Port

  • SSH Username

  • SSH RSA Key

  • (optionally) SSH Local Bind Port

Please reach out to the Explo team at support@explo.co if you have other security constraints.