- Database Setup
- 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
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
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, add the following roles
- BigQuery Job User
- BigQuery Data Viewer
- BigQuery Metadata Viewer
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.
If your database is behind a firewall, you will have to whitelist the following
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 RSA Key
(optionally) SSH Local Bind Port
Please reach out to the Explo team at firstname.lastname@example.org if you have other security constraints.