Why Does My Deleted Fivetran BigQuery Staging Schema Keep Reappearing?
Question
Why does the fivetran_<group_id>_staging dataset in BigQuery come back after I delete it? Can I remove it, and what is it for?
Environment
- Destination: BigQuery
Answer
Fivetran uses the fivetran_<group_id>_staging dataset as temporary storage during syncs. We keep it in place to reduce the overhead of repeatedly creating and deleting this dataset. If you delete it, we re-create it during a later sync.
The dataset stays empty except during syncs and has negligible storage impact. If needed, you can hide it with your data governance or catalog tools.