When you have GA4 to Big Query set up in a sandbox, your table will expire after 60 days.
Here’s how to un-set that expiry. Manual instructions and a SQL code generator tool.