Using Retool to build internal dashboards that combine data from multiple sources

Hi everyone,

I'm interested in learning how others use Retool to build internal dashboards that combine data from multiple sources, such as databases, APIs, and spreadsheets.

What challenges have you faced when connecting different data sources, keeping information synchronized, and making dashboards easy for non-technical team members to use?

I'd be interested in hearing about your approaches, useful components, and any best practices you've learned along the way.

Summary

A community member is asking how others use Retool to build internal dashboards that combine data from multiple sources (databases, APIs, spreadsheets), what challenges arise when connecting sources and keeping data in sync, and how to make dashboards approachable for non-technical teammates.

AI Response

Retool is well-suited to this: each data source is added as its own resource, and individual queries pull from each one independently. To combine results from different sources into a single dataset (e.g., for one table or chart), the common approach is the Query JSON with SQL resource, which lets you JOIN/UNION the outputs of multiple queries using standard SQL; JavaScript transformers are an alternative for custom merging. For keeping data fresh, set queries to run on page load or a timed interval and re-trigger dependent queries after writes, and for non-technical users, lean on controlled inputs (dropdowns, date pickers, search) wired to query parameters rather than exposing raw queries. The resources below cover the mechanics and community-vetted best practices.

Sources

:bookmark: Query JSON data with SQL statements | Retool Docs
Official guide to the Query JSON with SQL resource, the standard way to join and combine the results of multiple queries from different sources into one dataset.
:bookmark: Best Practices for Connecting Multiple Databases in Retool
A solved community discussion that directly covers best practices and approaches for connecting and working with multiple data sources in a single Retool app.

The Community Team is testing out a new automation. Let us know if it's helpful (or not) by leaving a :heart:, :+1:, or :-1:. Or by marking this post as the "Solution"! Let us know if you have any feedback here. :rocket:

One thing I'd be careful about is how fresh the data is across different sources.

If your database updates every few minutes but a spreadsheet only gets updated once a day, the dashboard can show numbers that don't quite match, even when nothing is actually broken.

I'd probably keep a last-updated timestamp for each source and make that visible somewhere in the UI. Also, having a stable ID to match records is pretty important. Joining by names can get messy surprisingly quickly.

Another small thing: I'd show missing data differently from zero. It's easy for someone looking at a dashboard to assume they're the same.

Are you mainly building read-only dashboards, or will people also be editing records from Retool?