Hello. I have a question. How can I merge data from different databases into one table?

App Building
1

I need to retrieve UUID from the first database based on user_id and then, using the obtained UUIDs, retrieve status from another database. Finally, I need to merge all of this into one table.

2

Hello and welcome to Retool!

It sounds like you just need to join all of your data in your resource query. This might be a simple join of data in one query, or you might need to make several different queries and then join the data via transformer/javascript.

Is all of your data coming from the same database server/resource? That would make it a bit easier to do like:

SELECT * 
FROM tableA 
JOIN tableB 
ON tableA.uuid = tableB.uuid

For your case, you would select the UUID and then do another join on the selected data.