Why Multiple Data Sources?
There are a few different reasons why you may want to connect multiple data sources to Explo:- You want to connect and build dashboards against both your staging and production databases
- You have customer data segmented into multiple different databases
Explo allows you to folder your data sources by schema to configure which
queries run against which data sources. For more information, navigate to the
Managing Schema
section of our documentation.
View Data Sources
To view all connected data sources, navigate to the Data tab.

Add a Data Source
On the Data tab, click the “Add Data Source” button to add a new data source. First, you’ll be prompted to enter a display nickname and id for your database, along with choosing its schema and visibility group. For more information about visibility groups, check out this section of our documentation.
Connecting Customers to Data Sources
Customer API
Every customer you create in Explo is associated with a specific set of data sources, one for each schema. When you render the dashboard for that customer, it will pull all data for that view from those data sources associated with the customer. When you create a customer via the API, you can optionally specify adata_source_id
or the data_source_provided_id
. This will associate the user
group with that data source for the schema that data source belongs to. If you
do not specify the data source, it will associate the customer with the
default data source, which you can configure from the data page.
For more information, go to
our section on the Customer API.
You can retrieve the data default
data_source_id
by going to the data tab and
looking at the number ID for the data source (47).
You can assign a
data_source_provided_id
in the data tab which then can be
used to identify the data source in your API requests:
Customers Tab
On the Customers tab, there are dropdowns for choosing a data source for each schema when editing or creating a customer. If no data source is selected for a given schema, that customer will be associated with the default data source for that visibility group and schema.