# Aggregating multiple bigquery datasets

**URL:** <https://discourse.getdbt.com/t/aggregating-multiple-bigquery-datasets/18019>\
**Category:** In-Depth Discussions\
**Tags:** bigquery\
**Created:** [February 3, 2025, 7:33pm UTC](https://discourse.getdbt.com/t/aggregating-multiple-bigquery-datasets/18019 "2025-02-03T19:33:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![wes](https://avatars.discourse-cdn.com/v4/letter/w/e9c0ed/32.png) [@wes](https://discourse.getdbt.com/u/wes)\
**Post date:** [February 3, 2025, 7:33pm UTC](https://discourse.getdbt.com/t/aggregating-multiple-bigquery-datasets/18019/1 "2025-02-03T19:33:40Z")

</div>

Hi! we currently have about 200 datasets that begin with a string ie. `analytics-`. They all contain the same tables with the same schema. Is it possible to aggregate them all into a single dataset using dbt? Any help would be greatly appreciated!