How to optimize query that needs to join BigQuery with Postgres?

[ScottR]

I agree...
If this is something you don't need to do often, perhaps workflows will help...it's in beta...I believe.
Check out this post... You might be able to do a workflow as suggested by @alina.retool

Create Workflow to trigger App to run periodically and cache results to improve performance

Hey Leon, welcome and thanks for the question! I'm checking in on this with our Workflows team internally, and will circle back with some help when I get it. Hang tight, thank you!