[sa46]

Is the idea something like a scheduled:

   INSERT INTO bq_table SELECT * FROM EXTERNAL_QUERY('');

I'm guessing you're on the hook for keeping the schema up to date with the Postgres schema.