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

🤝 Discussion
1

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.

2

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: