JOIN postgresql table & googlesheets table

Is there any way to JOIN postgresql table and googlesheets table?

Hi egerai!

This would need to be done inside of the frontend of Retool which isn't particularly efficient (especially if either is very large)

For small datasets I would recommend using the Query JSON with SQL query type

For larger datasets, I would unfortunately recommend setting up ETL or manual imports to add that data into your postgres database itself